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
Adding new column with text starting with and x length long
With these values in an Excel Table named Table1:
OrigVal 1 12 123 66778 1234567