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

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.

#Excel #PowerQuery #ExcelTips

[VinayKumar-qrfw]

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

[vreetdubariya]

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

[hendrag]

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

[mervinmandem]

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

[MaydayAggro]

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.

[aravindsuresh]

If it’s show null in the blank how to replace it sir

[anasahmad]

hello bhai can you put course on powerbi and sql

[juliajankowska]

Thank you very much, you are a great teacher

[skmubarak]

Aapki voice change hai. I think 💭 Aap Sumit Bansal nhi ho??


kya sahi hai ye??