Forum Discussion
Combining 2 tables both have duplicate values, need help!
Attached is the Excel File as I set it up with the Power Query
It'll take me a while to separate it out. It is on an Excel Sheet that has lots of other stuff in the workbook.
But here are some steps to follow.
Make sure your first table is named Cost.
Make sure your second table is named Order.
Select `Data => from Table` for each of those two tables.
After the PQ UI opens, select `Close and Load to` ==> `Connection Only`.
Then return to the PQ Editor and select a New Query with Source = Blank.
Go to the Advanced Editor and paste the code into the Advanced Editor, replacing everything that might be there.
Took a while, but i managed to add some columns for my report, worked great. I learned a lot, thank you, you guys helped me a ton—my sincere appreciation to everyone for their help.