Add information to an excel file (as data source) from another excel file

[Anonymous]

Hi, 

pls advise me how I can add information to an excel file (as data source) from another excel file. For exaple, I have a POS list sorted by customer ID and I need to add a customer name and loction from another file. The lists are connected with each other by ID number (as a key). 

[jppv20 · Accepted solution]

Hi @Anonymous ,

In PowerQuery go to the POS list table. Click on the top left of the table and choose Merge Queries.

Select the other table, the columns on which you want to merge and choose Left Outer.

This should give you the result you need.

If I answered your question, please mark it as a solution to help other members find it more quickly.