Combining specific data from 2 spreadsheets

Hi nlaauw 

Download this sample PBIX file with code.

My sample file loads data into 2 tables and then does a merge to get the ID from the 2nd table into the first

Select the Places query and from the Home tabe in the PQ editor, click on Merge Queries:

Giving a result like this

I don't have access to your original source files so you will need to load those into PBI and merge them, but following my example it should be pretty straight forward.

If you get stuck, post back.

Regards

Phil

Thanks so much PhilipTreacy When I merge them, it says 'table' in every row. I noticed in your example of applied steps that it had the same, but then is followed by "expanded codes" however I've looked and can't seem to find that option anywhere. Could you please tell me where that would be?