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

Company Page

[lgrover]

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

[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

[petrb.]

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

[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 :)

[angelala]

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

[dancer]

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.

[GurditSingh]

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

[SFJourney]

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

[Nevir]

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

[pancux]

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

[Excellent]

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

[tanveerhussain]

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

[nathanlemanski]

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

[programmesadmin]

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

[SachinKumar-jtzg]

Watched this yesterday, the finest example. Thank you

[jeremymcclung]

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

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

[canhuynh]

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

[emilyrich]

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

[thaboshikwambane]

I like the teaching style. Showing us various solutions