10 - Combine Excel Tables in the Same Workbooks Using Power Query (Formula Method)

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

Күн бұрын

In this video, I will show you how to use a formula to combine different Excel tables into one table using Power Query.
I take an example of Excel tables for different regions where you can easily combine the data for different regions into one single consolidated table using Power Query. You can also transform the data so that your final consolidated table only has the columns you want.
✅ 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

Пікірлер: 21

@sourabhbisht17 20 күн бұрын

Your English is easy to understand 👌

@hendrag593 2 ай бұрын

Thank you very much for this great video. You have explained it very clearly. GBU..

@VinayKumar-qr5fw 3 жыл бұрын

Hi Sumit, thanks for the session, It would be very great if you prepare a complete session on Power BI (Basic to advance)

@prasadgrandhi2056 3 жыл бұрын

Excellent explanation...

@juliajankowska853 2 жыл бұрын

Thank you very much, you are a great teacher

@hyiderali2124 Жыл бұрын

Thanks Jigs, YOu made my work easy

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

Thanks so much.

@FRANKWHITE1996 4 жыл бұрын

Thanks!

@mervinmandem 8 ай бұрын

This is great. Are these excel files you are using available? I want to be following the steps you are doing manually.

@kamalgupta5831 4 жыл бұрын

Thank you,

@krishansingh5839 5 ай бұрын

Thank you❤❤

@Volynyanyn211 Жыл бұрын

Thank you

@silvestrecamposano6317 2 ай бұрын

Very nice...

@study4734 2 жыл бұрын

Thanks

@vreetdubariya283 Жыл бұрын

Hey , can u know what is the difference between combining and appending the tables

@MaydayAggro 2 жыл бұрын

Not sure which version of Excel you are using in the video. Could IntelliSense have been added, or is it in later versions? I am using Excel 365, and IntelliSense works.