Master Merging Data in Google Sheets

Рет қаралды 28,102

Жыл бұрын

Are you tired of manually combining data from different Source Sheets in Google Sheets? Want to streamline your workflow and save time for more important tasks? Look no further! In this video, we'll show you how to use the powerful merging capabilities of Google Sheets with queries and arrays.
First, we'll explore how arrays can help you quickly summarize and aggregate data from multiple sheets or ranges, and how to apply them to large datasets with ease.
Next, we'll dive into the world of queries, which allow you to filter and sort your data based on specific criteria and conditions. You'll discover how to use simple SQL-like syntax to extract only the data you need, removing the blank lines, and automate repetitive tasks.
By the end of this tutorial, you'll have the skills you need to become a master of merging in Google Sheets, and take your classroom efficiency to the next level. Whether you're a teacher, an administrator, or anyone who deals with data on a regular basis, this video is a must-watch for anyone looking to leverage the full potential of Google Sheets to track assessments, or create clear overviews for teachers to track student progress. So, join us and let's dive into the world of arrays, queries, and merging in Google Sheets together!
You can find the file I use in my video here: docs.google.com/spreadsheets/...
(Create a copy)
Learn more about Queries from Ben here: www.benlcollins.com/spreadshe...
Come visit me on my website for many more tutorials, resources and tips: sethideclercq.com/ or support the creation of this content by joining the channel to get access to perks:
/ @flippedclassroomtutor...
You can also check out my Patreon here: / eduflip 💚
SERVICES AND SOFTWARE I USE DAILY:
Video editing: sethideclercq.com/camtasia
Amazing screenshots: sethideclercq/Snagit
Website hosting: sethideclercq.com/bluehost
Screenshots and GIFs: sethideclercq.com/snagit
Courses: sethideclercq.com/teachable
Email lists and newsletter: sethideclercq.com/convertkit
Website building: sethideclercq.com/wix
GEAR AND RESOURCES:
www.amazon.com/shop/flippedcl...
kit.co/FlippedTutorials
My TPT Store: www.teacherspayteachers.com/S...
Disclaimer: Some of these links are affiliate links where I'll earn a small commission if you make a purchase at no additional cost to you. These videos have been made for educational purposes and all views or opinions expressed are my own.

Пікірлер: 43

@mrs.awhitesscienceclassroo9872 Жыл бұрын

SO EXCITING!! This will help so much, I have so much assessment data and it was getting out of hand. Can't wait to get it back under control!

@user-xq9bl1cv1h 6 ай бұрын

Great tutorial, this exactly solves my problem without installing any add-ons. Thank you so much.

@FranciscoPereiro 6 ай бұрын

I spent the whole day looking for a tutorial like this one and it helped me a lot, thanks. You've got yourself another subscriber 👍

@FlippedClassroomTutorials 5 ай бұрын

Thank you! and welcome to the community!

@user-qc1hb8nc4i 4 ай бұрын

So grateful for your help. Amazing!

@JamesAbela Жыл бұрын

The new studio looks amazing! Great to see you back in action!

@FlippedClassroomTutorials Жыл бұрын

Yes! Thank you! It's great to get back to making content.

@rafpeeters9731 Жыл бұрын

GReat how you make sheets look so simple. Thanks again, Sethi!

@FlippedClassroomTutorials Жыл бұрын

You're welcome 😊

@querida9051 10 ай бұрын

This tutorial is very informational and easy to follow! Thank you so much 🥺

@FlippedClassroomTutorials 10 ай бұрын

Thank you!

@omarreroch Жыл бұрын

Great tutorial

@leekspinner 7 ай бұрын

thank you!

@soumyajeetmitra6958 4 ай бұрын

great easy tutorial

@silvestrecamposano6317 10 ай бұрын

Thank you very much for the technique that I can use in my office work...

@FlippedClassroomTutorials 10 ай бұрын

Glad it was helpful!

@alexherrera3918 Жыл бұрын

This is a google sites question: I added a widget for google reviews, but the height set but the widget is too big , is the a way to adjusted when I embed the link in google my sites? I hope you can comment. Thanks

@yasufumithebest 11 ай бұрын

how if I dont want the same name to be repeated in the master list, what formula we can use on top of what you have show?

@silvestrecamposano6317 10 ай бұрын

Thank you for the technique!....

@FlippedClassroomTutorials 10 ай бұрын

You're welcome

@zUkrainak47 10 ай бұрын

amazing video, thank you so much!

@FlippedClassroomTutorials 10 ай бұрын

Glad you liked it!

@KukilDas 5 ай бұрын

Can we add new datas at the top row but inserting a new row? Whenever I add anything at the top, it does not reflect in the mastersheet but it only reflects when I add at the bottom.

@mooripo 4 ай бұрын

That's beautiful ! thank you

@FlippedClassroomTutorials 4 ай бұрын

Glad you like it!

@user-gf5to7yj9f 5 ай бұрын

Thank you! very helpful

@FlippedClassroomTutorials 5 ай бұрын

Glad it was helpful!

@MichaelFilipetti Ай бұрын

Can you add a column A (move everything over 1 column) and add the name of the Tab it is from? So each row shows if the data if from Part 1, Part 2, or Part 3?

@rakesharora4521 4 ай бұрын

I want to do the exact same thing but from different work books..how I can do that?

@etangrant7519 4 ай бұрын

Still useful! Thank you.

@FlippedClassroomTutorials 4 ай бұрын

Glad to hear it!

@christinathomas8602 3 ай бұрын

Once you have your master list, can you then sort the columns from A to Z etc?

@SuperFoodParents Жыл бұрын

🎉Woohoo, first to comment on another amazing tutorial 🏅

@FlippedClassroomTutorials Жыл бұрын

Yay! Thank you!

@sandorszabo2470 Жыл бұрын

Thanks for the link to Ben's spreadsheets page.

@FlippedClassroomTutorials Жыл бұрын

No problem! It's an amazing resource to have!

@michaelescamilla-rgvcpr3485 2 ай бұрын

is there a solution to change one cell such as adding a formula that will copy the same information to the entire worksheet? In excel, you select multiple tabs and make change, however that does not work in sheets. Every worksheet is exactly the same. Thank you in advance and this video was very, very helpful. I have subscribed.