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).



⚙️ Gear I Recommend:

Note: Some of these links here are affiliate links!

#Excel #ExcelTips #ExcelTutorial

[kalejtobiloba]

Thank you so much.. watched up 10 tutorials already but only yours stands out

[alibozorgi]

Thank you for the great tutorial:
No excessive commentary, no please like& subscribe, no time wasting! It is efficient, right to the point, and clear!
Also great job on zooming in-and-out to get us involved and make a clear pathway to do the task!

[himanshudalai]

Thank you Sumit for this useful video. Very few people have such knack of presenting in crisp, clear manner and you are one among them.

[jideadeboyejo]

Thanks
you made it look easy after searching for different content that explain merging two or more excel worksheet, i find this easy to comprehend

[themfu]

This is the best and most clear intro tutorial to PowerPivot. Well done.

[PeterHalasimind]

This is a real relief for people struggling with vlookups and loosing the game. Thanks for this.

[drewerd]

208
That's how many hours this will save me a year. Thank you.

[brendaomala]

Thanks for this wonderful tutorial!The best, clear, easy to follow and time saving.

[ClarkeSmithies]

This is an excellent demonstration of how to merge tables. Thank you so much.

[julieunruh]

This was so helpful! Now I know what steps to use for my assignment. Thank you for sharing this

[trentdelong]

bro, you dont even understand what this one video did for been spending weeks trying to learn how to use excel in general to help me create a method of fundamental analysis for my currency trading. ive been filled with self doubt and ive been feeling like its going to take forever for me to learn enough about excel for me to do what i needed to do. this one video just made my year. it was consise and so easy to understand...i finally have what i need to move foward, i cannot thank you enough! seriously. THANK YOU

[kevinwong]

Thanks! 6:11 to expand and select the columns from my merged table solved my problem.

[philpoma]

Just came across this and was able to use it for a project I'm working on...thanks for putting this out!

[Invertedzero]

This makes things much easier, was getting tired of inserting columns for lookup formulae

[annafox]

I just wanted to thank you for this tutorial - it just saved hours of time for me! Hope you're having a good day :)

[nataliapopova]

extremely useful! thank you so much for this tutorial :)

[allacroix]

Excellent demonstration for using Power Query to merge existing Excel tables. I've subscribed and will likely be back for more tips. Thank you.

[schow]

Excellent tutorial. You really saved my day!

[satishbalaji]

Thank you..
I was struggling hard merging the table with huge data.
Saved my time and got accurate data.😊😊

[nuwandaish]

Thanks! Easy to follow and saved me time!