Notifications
Clear all
Power Query
2
Posts
2
Users
0
Reactions
142
Views
Topic starter
I am new to PQ
I have 4-5 excel file all with a common ID. I have been using index match to pull different columns out into a master file. Is there a way I can use PQ to and add columns from each file easier? I am weak at PQ.
Posted : 12/03/2017 3:28 pm
Hi Bill,
ou have to add queries for all those files, then merge them using the common field. The last step is to expand only the columns you want to add.
Here is a link to a useful article: https://www.myonlinetraininghub.com/excel-power-query-vlookup
Posted : 13/03/2017 1:40 am
