Google Sheets - Combine Data From Multiple Sheets (Tabs) Tutorial

Learn how to Combine Data From Multiple Sheets (Tabs) in Google Sheets using arrays & QUERY Function and make an automatic master sheet with all the data combined into one tab.
Google Sheets
www.google.com/sheets/about/
Company Page
www.chicagocomputerclasses.com/

[@jeremymcclung1692]

This was exactly what I was looking for. Thank you for taking the time to explain why you did what you did in the video. Amazing!!!

[@Excellent625]

Thank you a million. Frankly speaking, When ever I have a question, I find the answer in one of your videos.
All the best,
Thamer

[@programmesadmin2943]

This is brilliant. I've been looking for a way to do this, and add in new rows dynamically, for several months. Thank you!

[@petrb.9596]

I just need to tell you this video is piece of art. Extremely valuable.

[@lgrover55]

Finally - a methodical - clear tutorial style. Thank you, and keep up the good work.

[@alexandreborborema3454]

Awesome! This is exactly what I need to bring data from different sheets together before exporting to Data Studio. Thank you so much!

[@emilyrich2616]

Your videos have been SO helpful! They are the first place I go when I need to figure something out. Thank you! Thank you!

[@GurditSingh013]

why would anyone thumb down, thanks mate for the video, great help

[@sarahjanetolle]

This was incredibly helpful. Your explanation was perfect for my scenario. Thank you!!!

[@SFJourney52]

Excellent video. Merging multiple sheets is a challenge and this is what I needed

[@angelala525]

very useful step by step even after 6 years! greetings from Malaysia and bless you for the talent.

[@woundedsaloon7870]

Fabulous tutorial, very well explained and helps me to accomplish just what I set out to do. Thank you!

[@learnfix5725]

Clear concise and covers a useful technique. Excellent video, thank you.

[@kaitcorrado9626]

Thank you! This video is so clear and it's making my life so much easier right now!

[@nathanlemanski6961]

This is exactly what I needed to do and didn't know where to start. Thank you so much.

[@pancux670]

Your videos at Google sheets are awesome. Every novice can learn from it. Thanks

[@daverukamp6082]

Perfect solution for the question I had. Great job explaining! Thank you.

[@adrianwalton6715]

Really Helpful for me.... helped me with a task I have been pondering for quite a while. Well done series of tutorials.

[@akassebaum]

This was really awesome! I've learned something helped me solve a problem that I couldn't do on Google Sheets! I was surprised how easy this was!

[@teknikalWizz]

This is a fantastic tutorial. Exactly what I wanted

[@Andreye1122]

This senior is a great teacher!

[@SachinKumar-jt3zg]

Watched this yesterday , the finest example. Thank you

[@RajeshKumarPV]

Thank You. Never wanted in my life. Now when my 10 year old wanted a record of her read books (from library/borrowed/own/kindle/audible), i thought of having different tabs and getting the result in a final one. This helped a lot ! Thanks again

[@KST12345]

Thank you man, needed this for my job and looks like your channel will really help me!

[@rebeccacraft9375]

Thank you for this tutorial! Exactly what I needed.

[@getdavemoore]

This was the video that turned me on to QUERY :) (glad to say I've come a long way since then!)
Still watching every video you put out, so huge thanks !!!

[@ExcelGoogleSheets]

Great to hear!

[@muneebahmed2268]

Amazing man. That worked perfectly

[@monicadevlin9861]

This was awesome. Thank you. Your tutorial was very easy to follow and understand.

[@tanveerhussain3881]

World's Best Teacher
Best Quality
Learn Easy and Understand
I Love And Like All Video

[@leonardoplaza7677]

A life saver man! Thanks a lot. This was useful for my Google Data Studio Report

[@CeleronS1]

Dude you are AWESOME, even 5 years in future!!

[@thaboshikwambane5578]

I like the teaching style. Showing us various solutions

[@ShoaibBiradar]

Thanks man I was struggling with filter function for this .. appreciate it man😊

[@Nevir202]

Rather than the giant "or" statement, you could make a helper column which contains a COUNTA formula which counts the number or cells in the range containing data, then filter by those where it doesn't equal 0, or if you wanted to use null, you could force null if the COUNTA = 0

[@sarahtemmer4332]

Thank you so so much for this- exactly what I needed!!

[@golevka]

This was incredibly helpful! Thank you!

[@iandthopper]

Very useful and well-presented. Thank you.

[@naveenn7101]

Very Useful Function. Thank you Very much.

[@baovo2633]

thank you very much!. It saved my life today!

[@gmanova]

very very nicely done and explained, you helped me out. thanks!

[@mehmetkaya4330]

Great tutorial! Thank you sooo much!!!

[@ritchiefuentes64]

This is fantastic! Thank you!

[@sheilamariesagario9432]

This is amazing! Thank you!

[@dmwilson34]

Very clear!! Thanks so much!! 3 thumbs up!

[@Basudeb_Chandra]

thanks mate ,,,you save my day. loved your tutorial's

[@brunocesar2283]

You are the best!

[@lpanebr]

This is very clever use is filters with the query function. Thanks!

[@axelm6642]

Thank you! Very useful

[@grendbelema]

enjoyed this, thanks for sharing

[@dancer004]

This is helping me so much. My only problem is now I need to sort some data now that it's all complied, but it's sorting it within each array when I want it to sort through all of the data together (I don't even know if that makes sense). Basically I'm pulling data from 5 sheets into 1, and now I'm trying to sort highest scoring to lowest scoring overall, not from within each separate sheet.

[@darinchancellor6268]

Thanks for the video! So helpful!!

[@magnuscarlos7482]

Man you just helped me solve so much trouble!

[@parambharti7095]

Very Nice Tutorials..

[@rodolfoeduardo5488]

that's what i needed. Thanks a lot!

[@joshginther7505]

Incredible! Thank you!

[@sreejitsnair]

Thanks a ton. This has helped me a lot!!

[@CalmingSoundZZZ]

Super helpful. Thank you!

[@paulhewett8376]

Awesome video. Thanks for sharing.

[@danielkeebler6205]

Nice video! Great explanation.

[@andrewg449]

Awesome tutorial! Thanks:)

[@Biketherapy113]

killer video, thanks again super excited for video 3. :) and also looking more into learning queries.

[@netboy1102]

always helpfull tutorials, thanks alot

[@miguelrivas3781]

Thanks man, i didnt't realize I was adding those blank cells... great video.

[@ExcelGoogleSheets]

👍

[@carlosrobinson9153]

Very Helpful, Thanks

[@hovupham6741]

Thank you so much and appreciated.

[@chris_diab]

Fantastic video tutorial

[@barakahprogram2883]

Great thanks !!! that really helps

[@fernandodelperal]

Excellent. Thanks, very useful

[@mitulshah7020]

Many Thanks for wonderful video - it really helped a lot

[@joshuaharvey9271]

Great video, thank you!

[@kornth]

Thanks for good help.

[@alexkong93]

you guys r great!! thank you

[@gopakumarpillai6754]

Thansk alot.... The Tutorial is very Help full and you are a good trainer..... "Subscribed"....

[@mrgreggles998]

A clear explanation and practical usage; thank you! Subbed. :-)

[@ChadFi]

Great video, thank you sir

[@RobertLongM]

Miracle worker!

[@mike23mtz]

Great video, thanks.

[@chalkerian6181]

Thanks a lot for the video. It did help me!

[@patelvidhu4840]

Thanks. Very good video on google spreadsheets.

[@sylvierhufet1207]

Thanks for the video. It helped me to find a good solution:

[@mattooa]

Super Video. Thanks

[@kalaiarasank5138]

Thanks you so much.. it's really very helpful...

[@andreeapana1309]

Thanks! Very very good video!

[@MoussiToufik]

thank you i have setters and now i made a 38 pages and it worked

[@hermawanyulianto2645]

Thank U very much...very very useful .

[@canhuynh3670]

Thank you! Clear and concise.
Is it possible to also add a function to auto-sort the data by a specific column?

[@rcgiven]

This is a great video... one important thing to note... the column reference in your query is case sensitive. col1 will not work, but Col1 works :)

[@ExcelGoogleSheets]

That's correct!

[@ianbendelow2292]

Fantastic video! Thank you so much.

[@ExcelGoogleSheets]

Glad you enjoyed it!

[@JordanTomasone]

great video! Thank you :)

[@gradyraymer3115]

the ZERO!!!!!!! Thanks - that was what was throwing me off and making the first bit of data collect several cells and combine.

[@diggiemaster5162]

Thank you. This would make our report automated. :)

[@scavihue7543]

Thank you very much. You are just great for this helpful tip.

[@ExcelGoogleSheets]

Glad it was helpful!

[@fernandomgarin]

GENIUS. THANKS.

[@arinamcdonald1849]

Your awesome. Thanks for the video

[@prasoonkalantri9532]

Thank you sir it helped

[@DylanAmos-rz3gs]

This guy is the top G

[@imamsibromuhlisi1520]

Great. Thanks a lot !

[@khaledaboelhamd]

thank you very much

[@tipstechno6139]

thanks you so much, its very helpfull

[@NaftuliSinger]

This is amazing, I have a lazy way of using what you show in the first part on a hidden sheet, then filtering that with the filter function on another sheet...