11 - Merge Tables in Excel using Power Query

Рет қаралды 44,210

4 жыл бұрын

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: bit.ly/power-query-download
☕ If you find my Excel videos useful and would like to support me, you can buy me a coffee - www.buymeacoffee.com/SumitB
Free Excel Course (Basic to Advanced) - trumpexcel.com/learn-excel/
Best Excel Books: trumpexcel.com/best-excel-books/
Subscribe to get awesome Excel Tips every week: kzfaq.info...
#Excel #PowerQuery #ExcelTips

Пікірлер: 32

@alialbayati9368 4 жыл бұрын

Really impressive! You made it so easy to understand. thanks a lot for this tutorial.

@sdseka29 Жыл бұрын

Your time is highly appreciated. That was very clear demo on merge using Power Query. Good Work.

@sivas9443 4 жыл бұрын

Thanks for the wonderful video ! you are a great teacher !

@MoMoWFH 2 жыл бұрын

🙏 thank you. Your videos are extremely useful.

@minadev1 Жыл бұрын

Truly thankful to your effort and time

@Justonesec1 3 жыл бұрын

This is great. Thank you, sir!

@gogreenthousandoaks8554 Жыл бұрын

great tutorial with very clear steps.

@forpupo 3 жыл бұрын

Wow, I like your tutorial so much!

@user-sd1mv8nf6d 8 ай бұрын

Great job! It is very easy to learn Power Query with you

@VikasSingh-em3ol 4 жыл бұрын

Thank you sir for uploading power query videos .

@matthewparkes2336 Жыл бұрын

loving these videos

@ruslanazimov8616 5 ай бұрын

Made everything easy to understand Thanks

@umerhasham9842 4 жыл бұрын

Thanks a lot sir, its just amazing , u made it easy for us :)

@vermasanjayful Жыл бұрын

Very useful. Thank you sir👍👋

@minadev1 Жыл бұрын

Love it, please make more courses for Data Analyst

@GaganDeep-mj5hi 2 жыл бұрын

Very informative videos

@prasadgrandhi2056 3 жыл бұрын

Thank you very much......

@akashmon5065 4 жыл бұрын

Thank you, sir

@FRANKWHITE1996 4 жыл бұрын

Thanks !

@simranjeetsingh4101 Жыл бұрын

Thanku sir.

@margad-erdeneboldbaatar4704 2 жыл бұрын

Thanks so much.

@surajbhardwaj428 3 ай бұрын

Wow...best video brother..i want to learn full Power Bi..and I will learn this skill on your channel

@Musicworld-sd2hn Жыл бұрын

Nice thanks

@imanjafarov3754 Жыл бұрын

outstanding

@ChrisKalil-id2ki 8 күн бұрын

thanx

@maheshdoke8181 2 жыл бұрын

Pls Upload Video for Power Pivot

@sallyho146 7 ай бұрын

Thank you for the video. When I merge report 1 (RentRoll) and Report 2 (Roster), I didn’t get ‘The selection has matched 441 out of the first 441 rows’. The numbers don’t match. How can I fix it? I know the Roster Report has customers who are on hold. But the rent roll doesn’t include customers on hold. How can I add customers on hold in the merge report please? Thank you!

@rahulkalingeri1206 3 жыл бұрын

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!?