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:
Free Excel Course –
Paid Online Training –
Best Excel Books:
⚙️ Gear I Recommend:
Camera –
Screen Recorder – techsmith.z6rjha.net/26D9Q
USB Mic –
Wireless Mic:
Lighting –
Subscribe to get awesome Excel Tips every week:
Note: Some of these links here are affiliate links!
#Excel #ExcelTips #ExcelTutorial
Watch more new videos about Excel Office | Synthesized by Mindovermetal English
awesome, solved a lot of time and effort.. Thank You Dude!
This is an excellent demonstration of how to merge tables. Thank you so much.
Thank you Ji
awesome ! it helped me . thanks for sharing
Thanks this was very helpful.
Very clear explanation. Thank you.
Thank you. very nice and sample.
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!
can you please also share the excel files you use for this , so that it will be easy to Practise?
Just came across this and was able to use it for a project I'm working on…thanks for putting this out!
Great stuff. Thanks!
This is a real relief for people struggling with vlookups and loosing the game. Thanks for this.
If you compare this with SQL tables, it still appears like many steps and dependencies to get to the final output, but at least it's more elegant than altering the data structure.
This cleared up my lingering confusion on why to use power query.
Thanks…great video
Good video
This was so helpful! Now I know what steps to use for my assignment. Thank you for sharing this
This makes things much easier, was getting tired of inserting columns for lookup formulae
This is the best and most clear intro tutorial to PowerPivot. Well done.
I know this is a good tutorial whan I heard Indian accent in the opening