Google Sheets - Split Data into Separate Tabs (Sheets)
Вставка
- Опубліковано 27 лип 2024
- Learn how to split a table into different sheets based on the values in one of the columns. This video walks you through the steps and shows you how to do this in two different ways. First, we will use the FILTER function, and then we will use an add-in called Power Tools.
If you are interested in Power Tools, please use this link to find out more: bit.ly/pt-FC
This is an affiliate link, and you help to support my channel when you use it. Thank you in advance!
🕒 Timestamps:
0:00 Intro
0:35 FILTER
3:55 Power Tools
5:23 Functions by Color
Learn more from Prolific Oaktree:
🌳 Next Video - Google Sheets - Use Functions by Color - • Google Sheets - Use Fu...
🌳 Related Playlist - Google Apps | Full Tutorials - bit.ly/google-tutorials
#googlesheets #powertools #FILTER - Наука та технологія
You just gave me back hours of my life. Thank you for sharing.
Any time!
Excellent instructions. Your voice is so calm and you make this information so easy to understand.
Thank you so much!
this just saved me SO MUCH time. Thank you so much!
This is absolutely amazing! Thank you so much for sharing this video!
Loved the birds chirping in the background . . . :)
Ah, thanks! I think the videos feel much better with them.
Hello Adam,
Thanks for the sharing the knowledge really its helpful in our work flow.
Appreciate your presentation and teaching.
I'm glad you liked the video. Thanks for letting me know!
Extremely helpful tool this power tools thing... Saved me a bunch of time. Thanks!
I want to split a spreadsheet by date. The data comes from google form and column 1 contains a timestamp (DD/MM/YYY hh:mm:ss)
I want to split by date only, ignoring the time. How can I achieve this? Also, can this process be automated so that I don't have to activate power tools automatically?
Thankyou
You’re welcome 😊
what if you want to do the same thing but with dates? I need all dates between Oct1-Oct 30th, to populate in the new sheet.
So just as you did yours by city, I’m trying to do mine by zip code. For example I have 3 rows that have 55553 I’m trying to put on a separate sheet using power tools. When I run it just like you did, it creates 3 sheets for 55553, instead of putting them into one sheet. What am I doing wrong?
This is very helpful - what if you wanted to see more than just one condition? For example you wanted a tab that shows ABC and JKL on the same tab ?
Hello Christine,
We have another tool that can help with that - Multiple VLOOKUP Matches. It pulls data based on multiple conditions. Feel free to check out this video tutorial: ua-cam.com/video/wC4S03iSLHQ/v-deo.html
Hello sir. I've been watching your videos and they are all informative and such a helping hand for a beginner like me. I have one question, i had hid many sheets before, around 100+, is there any shortcut on how to delete the hidden sheets without opening it one by one? Thank you so much for your guidance
I'm glad you enjoy the videos. I don't know of a shortcut.
Liked the feature and it worked well. Just one question, if I changed a value in the main sheet. for example the first name for the first line which is located in Boston in the Data sheet. Is there a what that the first name in Boston sheet will be updated automatically?
Great question. The feature in Power Tools to split sheets is a one-time process and is not designed to remain linked to the original data. You would need to use a different technique for that.
Your videos are AMAZING!!!!! I have a question. If I want my form responses to dump into different Google sheets based on a particular value is that possible? I’ll use your video as an example. If the Google form asked a person which city they were from with a drop down menu and they clicked “Boston” is it possible to have all future data to automatically dump into the “Boston Sheet”? And have a different sheet per city (this is for a real estate team, I’m creating a “client info sheet” and when the client picks a specific agent, I want their contact info to dump into that agents client sheet) hope that’s possible haha thanks!
I think you'd have to dump them into one sheet then create different sheets from that one table.
Does this feature allow auto updates? For example... I receive new spreadsheets on a daily basis and use conditional formatting to color my fields based on multiple different statuses. I don't want to have to delete the entire spreadsheet and have to run the program over and over and re add my formats. Does this have a feature that allows me to delete the raw data and replace it with the new data?
If you mean Split Sheet, sorry but no - it doesn't know how to auto-update results yet. Thank you for the feedback though! We'll add the request to our roadmap.
@@Ablebits_com is there a new video for this? Really want one for categories that sorts it into different sheets but auto updates. Making a budget sheet and need it to pull in subsheets from main sheet
@@megansprague3232 Hi Megan,
Our Split Sheet doesn't update the resulting sheets automatically yet. The feature is in our roadmap, and we're going to introduce it in another version of the tool.
Alternatively, you can try Multiple Vlookup Matches: ua-cam.com/video/wC4S03iSLHQ/v-deo.html, or email our support team directly with a detailed description of your task, we'll be happy to help.
Can I sort after I use the =filter command?
Yeah, you should be able to sort the original data no problem. I wouldn't try to sort the output of the FILTER command though. Just change the FILTER syntax to however you want it resorted.
This did not work for me at all?
ARRGGHH this did not work for me :(
nc1