Log In
Register
Home
January 30, 2020
Offline
Hello!
If I have an excel file with, lets say 100 columns, but I only need the first 10 columns. Is there a way for me to import, via power query, just the 10 columns?
Thanks in advance!
July 16, 2010
Offline
Hi Kenneth,
Yes, get the data with Power Query. In the Power Query editor window, select the 10 columns you want > right click: remove other columns. Close and Load.
Mynda
New Member
April 26, 2021
Offline
Hi,
And how do I do the exact opposite - I have 10 columns in a file but want to load 100 columns?
July 16, 2010
Offline
Hi Giedrius,
Welcome to our forum!
I'm not sure how you plan to get 100 columns from a file containing 10 but I suspect using Power Query would be the wrong way to go about it. You probably should use a PivotTable.
If you still have further questions, please start a new thread and upload a sample file of your data so we can see what you mean.
Mynda
1 Guest(s)
