Installing Power Query
The Power Query add-on is installed by default in Excel 2016 and can be found in the Get & Transform section of the Data tab. However, for Excel 2010 and 2013, the add-on needs to be downloaded and installed. You can download the most recent version from
the Microsoft site.
There are three things you should know about this download package:
- It takes admin rights to install.
- You need to get the correct version: 32bit (x86) or 64bit (x64). This MUST match your
...
Knowledge Base Articles By Category
Recent Forum Posts
Create table that returns recent date for multiple rows of matching data; except dat
This code should do it for you