In this video, I will show you how to merge different Excel tables using Power Query.
Unlike appending the tables, where the columns needs to be in the same format, when you merge tables with Power Query, it need not be in the same format. If there is one common column in the tables, you can easily map these tables and merge these.
✅ Power Query Course Download files:
☕ If you find my Excel videos useful and would like to support me, you can buy me a coffee –
Free Excel Course (Basic to Advanced) –
Best Excel Books:
Subscribe to get awesome Excel Tips every week:
#Excel #PowerQuery #ExcelTips
Watch more new videos about Excel Office | Synthesized by Mindovermetal English
This is great. Thank you, sir!
Wow, I like your tutorial so much!
What if the two tables have different no. Of rows?
For ex: table A has 10 rows later I have table B (update of table A) with 15 rows
Is it possible to merge table A with table B and still show all rows!? Or should we check the table which has max. no. Of rows and then merge it with table with less no. Of rows!?
Thank you very much……
Can you please tell me a way to un-merge queries and delete existing Connections?
Thanks !
Thank you, sir
Thanks for the wonderful video ! you are a great teacher !
Same job you can do with vlookup?
Thank you sir for uploading power query videos .
Thanks a lot sir, its just amazing , u made it easy for us 🙂
Really impressive! You made it so easy to understand. thanks a lot for this tutorial.