Google Sheets - Combine Data From Multiple Worksheets (Tabs) into ONE ⇨ Filter ⇨ Sort (➕ Example)

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

Просмотров 7 тыс.

50% 1

Learn how to automate the process of combining data from multiple sheets, filtering the data and sorting them in ascending / descending order using QUERY formula in Google Sheets. In this tutorial, we'll use an example to show you how to do that so you can easily merge data located in different worksheets into ONE single tab for analysis / other application.
𝐖𝐚𝐧𝐭 𝐭𝐨 𝐬𝐮𝐩𝐩𝐨𝐫𝐭 𝐦𝐨𝐫𝐞 𝐜𝐨𝐧𝐭𝐞𝐧𝐭 𝐥𝐢𝐤𝐞 𝐭𝐡𝐢𝐬 ?
👉 You can now buy me a coffee @ ko-fi.com/T6T25PD0A
👉 Subscribe to my channel @ ru-vid.com?s...
👉 Shop Danalyser Templates Collection
@ www.danalyser.com
R E S O U R C E S
🪴 USE QUERY() Fomula for Advanced Data Manipulation - • A Case Study: Advanced...
🪴 QUERY Function Documentation - support.google.com/docs/answe...
C R E D I T S
⭐️ Thank you Hussein for providing the dataset so we can share the solution with ALL of you ! :)
T I M E S T A M P
00:00 The Challenge
02:30 Extract Selected Fields using QUERY ( )
07:26 Filter Data using QUERY ( )
10:20 Append / Combine Multiple Dataset
11:22 Sort Data in Ascending / DESC order
⭐️ NEW TO GOOGLE DATA STUDIO
Check out our FREE GDS Course (2022) here 👉 • FULL Google Data Studi...
We uses practical approach and covers almost everything you need to get started in Google Data Studio! Take the course now and shine ✨
F R E E B I E S
I used Canva to make graphics for my educational videos and thumbnails. If you want to try this amazing tool, you are welcome to use the link below!
Try Canva Pro FREE for 30 days: partner.canva.com/danalyser
[ This is an affiliate link. I receive a small commission if you decided to subscribe to the Canva plan after trying it out. There's no extra cost to you.]
#GoogleDataStudio #Danalyser
--------------------------------------------------------------------------------------------------------------------------
A B O U T M E
👧🏻 The person behind this channel is a Malaysian-Chinese Data Analyst. Aspired to create content for non-technical background audiences to up their game in their careers or even for students to prepare for their future career at early stages.
---------------------------------------------------------------------------------------------------------------------------
💌 W A T C H N E X T
⚈ Show current date in dashboard
👉 • Display TODAY's DATE a...
⚈ Export Data from Data Studio
👉 • How to Export Data Fro...
⚈ Automation in Data Studio (Email Delivery)
👉 • How to automate data s...

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

10 июл 2024

Ссылка:

Скачать:

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

Добавить в:

Мой плейлист

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

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

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

Selamat Datang! Welcome back and hello if you’re new here! 🙌 Do you think this video is useful ? Any feedback is welcome! 😊

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

Thanks! You helped me a lot.

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

Great video!! Thanks

@asg6275 Год назад

Very helpful! I love the A2:N notation to automatically include new rows as they are added and vertical concatenation using { query1 ; query2 }. Our dataset had Player 1 and 2 as separate columns (making up a team). I was trying to summarize points by player as they could compete on different teams. I created Query 1 for Player 1 and Query 2 for Player 2 and then concatenated them vertically using your technique. After sorting I preceded the output with dataset field names using A1:N1. Thanks!!

@andriantosutomo4559 Год назад

Thank you miss, really helpful for me to excel my proficiency in spreadsheets!!! 👍👍

@danalyser Год назад

Glad it was helpful, Andrianto ! 🎉

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

Thanks for sharing this tutorial , it was very helpful and solved many of my problems in addition to the knowledge of using the QUERY Function in excel appreciated

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

Thank you Hussein, so glad it was helpful. Thanks for the dataset btw, very helpful for me to put together this tutorial ! :)

@DaveVT5 Год назад

Thanks!

@danalyser Год назад

Thank you for supporting this channel David! 😊

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

Thanks a lot

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

Happy to help

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

Is there a way to add an extrda datapoint on that final combined sheet that will tell me what sheet the original data came from? (I can send you a loom if that helps explain my question)

@ArturLaiber Год назад

By the way, @danalyser, how would you combine data from similar worksheets if they where in different workbooks? And, being more precise, the real case is for 100 different worksheets. Thanks!

@josephcruz4736 Год назад

Hello Dana! You get an error because, on your first query, you select the entire dataset A2:N. You can fix this by limiting the number of rows, for example, A2:N18. But yeah, great tutorial as always! Keep it up!

@danalyser Год назад

hello Joseph! Nice to see you here again 🤓 oh thank you for pointing that out 🙏 ✨ Glad you enjoy the tutorial 🤘 Thank you again for always being supportive! SL