AWESOME Excel trick to combine data from multiple sheets

Подписаться 617 тыс.

Просмотров 1,1 млн

50% 1

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 📗📗👇
================
Download the sample clinic data here - chandoo.org/wp/wp-content/upl...
Combined workbook with query - chandoo.org/wp/wp-content/upl...
Article on how to use Power Query - chandoo.org/wp/power-query-tu...
Learn Power Query (complete tutorial):
===============================
If you are new to Power Query then watch this complete tutorial (80 minutes) to understand it fully. • Power Query Tutorial -...
Want more? Get my Power Query mini-course here 👉 chandoo.org/wp/power-query-po...
My Power Query tips & tricks playlist:
==============================
Here is a playlist of all my PQ tips & tricks. Binge responsibly ;)
• Power Query Tutorial -...
Have a beautiful day 😀🌼🌞
#PowerQuery #Excel

Наука

Опубликовано:

26 июн 2024

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист

Посмотреть позже

Комментарии : 660

@balarajswamy1255 2 года назад

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.

@chandoo_ 2 года назад

Thanks Balaraj. I am experimenting with music on the videos. Glad to hear (excuse the pun) your feedback 😀

@sabkuchdhela191 2 года назад

Agreed

@rayjack Год назад

pls no music. I cannot hear you clearly. Your voice is muffled, not sharp and clear. pls no music. thk u

@manjunegi9986 Год назад

@@chandoo_ w

@alisandejj 2 года назад

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

@r080629 2 года назад

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

@chandoo_ 2 года назад

That is awesome to hear. More power to you in June Tristan.

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

@GurayVural-nz1lk Год назад

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

@vfrdavid 8 месяцев назад

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!

@brocky Год назад

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

@manojthomas9859 Год назад

Leaning this for the first time in life at the age of 46.

@nazarkamal8831 6 месяцев назад

What is there in age for learning sir !!! You are admirer for so many people's to learn in this age ❤❤❤

@arifulislam3083 4 месяца назад

Ha ha same from me

@hermask815 10 дней назад

Don’t feel bad, not every presented feature has been in excel for decades.

@the_pest_the_best 2 года назад

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

@chandoo_ 2 года назад

You are welcome Somashekhar... 😀

@mrCetus 2 года назад

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

@joannaroy4367 Год назад

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

@studymate8469 Год назад

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.

@PrashantMohan-seven Год назад

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

@mrodriguez8456 Год назад

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!

@chandoo_ Год назад

Glad it was helpful!

@mijobe2851 11 месяцев назад

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

@chandoo_ 11 месяцев назад

So nice of you

@Passion4Fashion2023 2 года назад

Love your videos, very educational. Will use this knowledge for my work. Thank you for educating us.

@rishak7441 2 года назад

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

@user-ye1ur3uc8e Год назад

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

@crafurl Год назад

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

@gloire83 2 года назад

I do not so often comment but I must thank you for this great tutorial. It was just what I had been looking for to consolidate multiple worksheets into one. Thanks again

@chandoo_ 2 года назад

Thanks for taking time to write the comment A S 😀

@rubennadevi Год назад

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

@abmusic82 Год назад

Thank you for this! I had mastered performing a query for multiple workbooks, but was stomped on consolidating sheets. This video was much appreciated!

@chandoo_ Год назад

You're very welcome!

@CS-zw5im Год назад

Thank you, needed this for work and it made my job so much easier! Thank you for sharing. 🙂

@Artistram3d1 Год назад

This is Brilliant! Had difficulty with placing copy from two sheets. Your method worked and I was able to successfully combine the two sheets seamlessly in my layout in InDesign. Thank you so much! (And yes, I've subscribed a while ago!) 😊

@tomphelan7396 2 года назад

Excellent video. Perfect to help me with something I've been trying to set up. Thanks a million!

@chandoo_ 2 года назад

You are welcome Tom ....

@dansnow8667 Год назад

I can't upvote this enough, THANK YOU Chandoo!!

@tracywilliams61 Год назад

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

@PaulasPicks 2 года назад

I work in a group of clinics & this was SO helpful, Chandoo! I appreciate you!

@chandoo_ 2 года назад

Wow.. thanks Paula. 😀

@SamCopper101 2 года назад

Are u on linkedin Paulas?

@winewithtuanni Год назад

This was so helpful. Thank you so much. You explain things very well!!

@davidburton9153 Год назад

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

@julsofthesand Год назад

Oh my.. you know how much it means to have this tutorial. Thank you.

@gmartshopper Год назад

AMAZING - Helped me compile 90 separate sheets into one!!!!

@redmicrouser7954 Год назад

Very excellent, clear, orderly and friendly presentation-- GOOD JOB !

@chrismalingshu 2 года назад

Very clear & useful explanation! Thanks Sir 🥰

@dogusturkan7096 Год назад

This was extremely helpful. Thank you for the brief and excellent explanation.

@mariyoreo Год назад

Thank you so much for the clear explanation!

@ritarochelle4745 Год назад

Excellent video! Very well done. Thank you for providing data source as well

@StephWells 13 дней назад

Thank you for sharing such a clear, concise and informative video. This has been so useful

@JiaLiang-cg3up Год назад

Thank you, guru. Eventhough I haven't learnt the power query throughly, but I'm able to achieve what I want as according to your guide. Nice. It's able to update with just a simple click (refresh) ! Super awesome!!! 😁

@harrisoncole9483 2 года назад

Great Chandoo, you are my data/excel scientist. I really love your videos. Thanks for the education

@jamesjennings8574 2 года назад

Thank you for doing this at a comfortable pace - so many others rush through it like you're an expert already -- If I were an expert, then why am I watching videos? Very well done!

@chandoo_ 2 года назад

It is my pleasure James. My mission is to help 1 million people every month. I am not going to get there by rushing... 😃

@angieevans33 Год назад

This just saved me amazing amounts of time! Thank you.

@kc7476 11 месяцев назад

Love this trick. Thanks so much!

@sallyho146 Год назад

Love it. Need to review the video again. It will help me with my monthly sales reports to combine them into 1 worksheets

@rechung Год назад

You are a gift to the world. Thank you.

@mathingulzar5522 2 года назад

Thank You Sir! Clean explanation. Solved my big issue for the day

@staceyboulmetis6862 Год назад

thank you very clear instructions!!!

@steveman4561 7 месяцев назад

This tutorial was of great usefulness. Thank you so much!

@Chris4Congress2010 2 месяца назад

Thank you. This is a HUGE help.

@Gundute 2 года назад

This was soooooo useful! Thank you very much!

@neilwood6328 7 месяцев назад

Thank you so much for such a clear and step-by-step approach. I've been searching for a solution to an issue, and this is exactly the answer. Delivered with care, and much appreciated.

@chandoo_ 7 месяцев назад

You're welcome!

@JoelHanley22 Год назад

Awesome help! Thank you!

@MrHardNails 2 года назад

Thanks for the lesson basics on Excel is very helpful in structure and giving me direction to develop my systems

@maliamatlali2898 9 месяцев назад

Excellent demonstration and explanation, thank you.

@TanayGurjar Год назад

This has helped me tremendously, much thanks for making this video!

@werrieswork4272 Год назад

Worked like a charm thanks

@songyuda 3 месяца назад

thank you Chandoo for sharing such a great trick. It's nice to enjoy the music while learning new tricks. btw, I've got a buddy also called Chandoo when we were studying and working in London....

@chandoo_ 3 месяца назад

That's great!

@isaacmireku5805 2 года назад

Wow Sir Chandoo. You have really impacted me positive with the learning of Excel. God richly bless you for your patience and intelligence.

@chandoo_ 2 года назад

You are most welcome Isaac. It is my mission to help one million people every month. 😀

@rexbk Год назад

Perfect thing for Power Query and a cup of coffee! Thank you Brada

@arianecacho5373 7 месяцев назад

Thank you so much. God Bless!!!

@user-xf9px8wi9z 7 месяцев назад

This was super helpful! thank you!!!

@Guycjohnsen Год назад

Thank you sir! Excellent video!

@rmmccarthy1240 Год назад

Power query and a cup of coffee! Right On👍

@nuraliafatihabintilaililnizan 4 месяца назад

Thank you so much! This was really helpful

@franciscomancuello8810 Год назад

So helpful and informative. Thankss!!

@izalmatt 5 месяцев назад

Thank you sir, its very helpful and much easier. I couldn’t have done it before.

@rlauezzari 14 дней назад

this was extremely helpful - thank you thank you

@AnuragSingh-ne5bz Год назад

You are my all-time favorite educator🥰

@ladyg3956 7 месяцев назад

Very helpful. Thank you!

@jessicadoench4305 4 месяца назад

Excellent tutorial! I've been wondering forever how to combine excel sheets into one!

@avvabaldur 3 месяца назад

Besides the great content, the music it's selected with so much elegance. All the best from Romania, Chandoo ! Thanks

@adelgonalves7839 Год назад

Great video! Thank you so much for this

@pidzyn Год назад

Superb explanation. That's that the answer to my issues. Thanks!

@mohdsamimali Год назад

Thanks bro. you solved that problem which I was looking for more than couple of days.

@andrewgeorge2853 Год назад

You saved me so much time.. Thank you!

@mansijswarnkar4389 Год назад

Thank you Chandoo !!

@amaraangel8433 7 месяцев назад

so understandable! thank you so much

@hamzawaheed47 Год назад

Sir, thank you very much! You are a REAL PRO!

@TaberBucknell Год назад

Wow ... just wow! You solved a massive problem I had of consolidating data sent to me in a workbook with 628 tabs! The result was one table with 25,100 lines! Thank you!!

@chandoo_ Год назад

Fantastic!

@NimaMSH 2 года назад

nice background music , great example for using power query . good job !

@chandoo_ 2 года назад

Thanks Amin :)

@asifjnu Год назад

Thank you very much Sir. It’s nothing less than miracle ♥️

@kenmcmillan2637 2 года назад

Thanks for the video. I absolutely love your sense of humor!! Keep it coming sir.

@chandoo_ 2 года назад

That I Ken do... 😃

@ariodhilla 11 месяцев назад

THANK YOU VERY MUCH I SEARCH THIS INFO FOR A LONG TIME

@keziadrevdal5766 11 месяцев назад

Love your videos! The best channel about excel I've ever found.

@danbarnhart2332 2 года назад

Literally my first time using any "power xxx" functionality. Fire tutorial.

@chandoo_ 2 года назад

Thanks Dan. More Power to you :)

@DisDutch Год назад

hello Chandoo. I followed your explanation and it all works, thank you so much. thank you

@rajmm260 3 месяца назад

Thank you so much for sharing this, it helped a lot

@timesavertricks 8 месяцев назад

thank you chandu sir. i was trying a lot to have added multiple sheets. and finally your this video helped me do it.

@savs_steinly Год назад

Awesome, thank you!

@ilgrim26 6 месяцев назад

I know I am late to the game but I just used this to help me track games that I want to play on XBox. I was able to make a spreadsheet for GamePass games and when they released so I have an estimate on which games will stay on GamePass and I have time to shelf while I am working on completing other games. Very useful video. Thank you so much.

@Zimoct Год назад

This is beautiful, sir. Very helpful. Thank you.

@kakashihaa314 7 месяцев назад

thank you very much sir, i gained a lot watching tour tutorial videos, very kind of you 🙏

@roshankrs Год назад

very clear can't be better than this

@SumeragiMinami Год назад

Thank you Chandoo, I learned a lot from just this video.

@muhammad0taufik Год назад

Thank you chandoo, this video make my work easier

@rchltrrs 10 месяцев назад

Thank you for sharing this!!

@kinsalvador4343 9 месяцев назад

Halo.... I now love excel even more, when I'd discover your channel. More blessings to you for your free amazing tutorial. I hope to become like you in the future

@vfrdavid 9 месяцев назад

I can't tell you HOW MANY TIMES I have had to manually copy/paste multiple tabs together into a single tab - I thought I needed to write VBScript - or buy some sort of 3rd party utility like Ablebits - this is AMAZING - and I kind of hate myself for not looking for this sooner!!! Thank you!!!