AWESOME Excel trick to combine data from multiple sheets

Reconcile & consolidate data from multiple worksheets automatically using this amazingly simple Excel trick. You can set up a repeatable process so that every month Excel automatically combines the data for you.

⏱ In this video 👉
==============
0:00 - Introduction to the combine sheets problem
1:01 - New file to consolidate the data
2:05 - Updating "power query" steps
3:07 - Cleaning up the combined data
5:35 - Loading data to Excel
5:58 - Testing with new data
6:48 - More Power Query

Sample files 📗📗👇
================

Learn Power Query (complete tutorial):
===============================

My Power Query tips & tricks playlist:
==============================
Here is a playlist of all my PQ tips & tricks. Binge responsibly ;)

Have a beautiful day 😀🌼🌞

#PowerQuery #Excel

[balarajswamy]

Loved how you added background music and small sound effects to the video. It made the watching more pleasant. Really good work and ofcourse the content was helpful.

[alisandejj]

You have saved me more time than you will ever know. Video was easy to follow and really clear. THANK YOU!!!

[GurayVural-nzlk]

Such a clear and well-paced video, explaining key concepts and demonstrating how they work in less than 8 minutes. Excellent, thank you!

[r]

I could not end my month in a better way. This saved me tons of time and i could meet my deadlines. Great video and beautifully explained. Thank you

[KymberleyBradshaw]

This was brilliant - THANK YOU, CHANDOO!! I wasted so much time trying to get a client's Excel book with sheets for every week of the year into one manageable sheet and thankfully I found your awesome video. Thank you!

[brocky]

This was excellent. It helped me combine a list of over 1400 lines in a clean format. Thank you!

[the_pest_the_best]

Thanks for sharing your all decade experience in 10 minutes... Love the way you take each examples practically...

[studymate]

YOU ARE AMAZING! I learned everything with a smile on my face while at it. I was understanding everyting that I am listening and seeing. It's hard not to smile when you realize that.

[joannaroy]

This tutorial was awesome! I've been trying to figure out how to do this for so long! Thank you!!

[PrashantMohan-seven]

You have always been a 10M+ superstar .. adding value in every interaction. More well earned success in your direction!

[vfrdavid]

This is one of the missing things in Excel I've had for SO long - so many clients keep monthly / weekly spreadsheets for things - and then expect to be able to get reports across a date-range - but - that is not possible - not until you do THIS to the spreadsheets - and the BEST part is - as they get updated - the Consolidating Spreadsheet can be updated - WOW - this blows me away - I know I should have found this YEARS AGO - just always went to an "actual" database - and had them import all of the individual sheets into database tables, and then took care of the reports - BUT - any updates to sheets - would NOT make it to the imported database tables - unless you deleted / re-imported the updated sheet(s) - which could get very cumbersome...anyway - THANK YOU - so amazing!

[crafurl]

Thank you! I've followed so many videos for this process, but this was the only one that worked for me!

[yeuruce]

This was exactly what I needed. Instructions where so helpful. I am going to get so much use out of this at work!

[mrodriguez]

Saw multiple videos on how to combine or consolidate data from multiple worksheets. This video was the clearest and most straightforward one - I finally understand Power Query! Thank you, Chandoo!

[mijobe]

Chandoo, you do a really fantastic job walking through it. I've come back to this multiple times. Many thanks.

[davidburton]

Thank you. I am using this knowledge to build a robust GIS data layer and this saved me hours of work!

[rubennadevi]

Thank you so much! Never heard of power query until now. This saved me so much of time!

[rishak]

This helped me so much better than trying to consolidate it. Thank you

[tracywilliams]

Wow perfect timing, I recently spent a good amount of time doing the manually. Can't wait to try in the morning

[GoldenSlumber]

Exactly what I’ve been looking for Chandoo. Thank you for sharing this fantastic tip!