Combine Data from Multiple Sheets in a Single Sheet

Learn how to combine data from Multiple Sheets of an Excel Workbook into a single Sheet using Power Query.

- - - - My Courses - - - -
✔️ Mastering DAX in Power BI -

✔️ Power Query Course-

✔️ Master Excel Step by Step-

✔️ Business Intelligence Dashboards-

- - - - Blog - - - -

[cautiouspanda]

Chanddep, I just consolidated a massive file that was related to a 100 Million dollar project! Kudos brother!!

[CatWhite]

Chandeep, this was fantastic. You clearly explained processes that others simply glossed over and I was able to complete an important project. Thank you!

[onidbibo]

Your method is much easier to understand & it helps me to consolidate all my data into one workbook.Thanks for posting this video.

[lyndabennett]

Amazing video! May God richly bless you for this wonderful tutorial 😊 This is much faster than other methods I’ve found that have you create individual sources per sheet, or try to use buggy VBA code.

[ameliajacobs]

THANK YOU! MY FIRST TIME CONSOLIDATING MY FILE INTO ONE WORKBOOK. THANK YOU A LOT!

[arunmishraajm]

I love the way you explained .. Great job.

[donteadoss]

Incredible tutorial — thanks so much, definitely SUBSCRIBED!

[Michael-ymxw]

Brilliant - thank you for sharing - saved me a ton of time!

[srinitnt]

Absolutely brilliant..! Thank you so much..! I never knew this and just applied to combine data from 167 sheets and it worked like butter smooth. Thanks a Ton..!

[delsolar]

Hello Chandeep,
Thanks a lot. Your trainings are perfect. I have a question: I need to transform and combine multiple files in a folder. In the "Transform Sample File" step, I need to add a column to the "sample file" which includes the most used text in a specific column. I can easily group, sort, keep first row, remove other columns and drill down the needed value. But when I go back to the previous "original table" step, the variable isn't recognized. By any chance, can you propose a solution? Thanks again for all your sharings.
Regards,

[robfrantz]

This is so helpful! Thank you so much!

[IrfanKhan-qmqc]

Glad to check this video, Found what i was looking for. Thanks Brother !

[nagautube]

Thanks much for this knowledge share, appreciated!!

[suvratrai]

Thanks for making this video, , helped saved a lot of manual effort for me.

[fortunatelekhuleni]

Thank you so much.. perfectly explained!

[arunkumar-beli]

Very Useful and Perfect Explain that how to Consolidate the Whole sheet in single Source of Sheet.

[shwetankansal]

Great explanation brother . Thanks a lot !👍

[HaPham-jgnf]

Appreciated to your lesson! You save my life 🙂

[TheJiten]

Thank you very much for wonderful explain

[leabalois]

😊 🎉 you always serve the best tutorial for complex function of power query. Thank youuu for your enthusiasm to share your knowledge!