How to Merge Two or More Excel Tables with Power Query

Power Query can be really useful when you want to merge different Excel tables.

Now I am not talking about tables with the same structure. With Power Query, you can merge different tables as long as there is a common column.

Earlier, this could have been done with lookup formulas or VBA, but that's too much effort when you can do it in seconds with Power Query.

In this video, I will show you the exact steps you need to follow to combine three tables that have different columns (with only one matching column in each table).

You can read more about it here: https://trumpexcel.com/merge-tables/




Free Excel Course - https://trumpexcel.com/learn-excel/
Paid Online Training - https://trumpexcel.com/excel-training/
Best Excel Books: https://trumpexcel.com/best-excel-books/

⚙️ Gear I Recommend:
Camera - https://amzn.to/3bmHko7
Screen Recorder - techsmith.z6rjha.net/26D9Q
USB Mic - https://amzn.to/2uzhVHd
Wireless Mic: https://amzn.to/3blQ8uk
Lighting - https://amzn.to/2uxOxRv

Subscribe to get awesome Excel Tips every week: https://www.youtube.com/user/trumpexc...

Note: Some of these links here are affiliate links!

#Excel #ExcelTips #ExcelTutorial