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
Extract data from 1 column in txt with Power Query
It is probably not a big problem to split the vertically arranged vendor blocks into individual columns, but in the end there will be too many columns...
pinarello Yesterday, 11:38 PM