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!
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
Hi,
And how do I do the exact opposite - I have 10 columns in a file but want to load 100 columns?
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
