Hi there! This is as super useful video, thank you! I have a question: imagine the 3 source sheet (january, february, march) have slightly different column layout. The columns may be in a different order or one sheet have some additional columns compared to the others. How in that case would you concatenate the three sheets? I've managed to do something that works by combining FILTER (the first 10 columns are the same for every sheets) and IF/VLOOKUP (to fill in the 20 following columns that are in different order). Is there a more efficient way to do this? I can't just change the source sheets because they are auto-updated export from a document management system
Great Video thanks... I'd like to do something similar except I'd like to add another column in the appended sheet (Qtr1) that would indicate where the data came from, ( ideally sourced from a cell within the original tabs). In your example it would populate the new column with the values "January", "February" and "March" for each row/record. Is that possible? Also can you say which is the fastest/most efficient to use in terms of processing time?
This is a great video! Found more like it but none of them allows the tabs to be deleted. Does anyone know how or if that is possible? I have a years worth of info I want combined into one year summary but not the individual months anymore. Do I just hide them?
Thanks for this I have learnt so much but am hoping I can call on your expertise now to take my master/combined sheet to the next level. I have created a filter view to show my permanent and casuals and now need to add in the master/combined sheet additional information to be retained when new data is added to one of the sheets that mergers into the master/combined. Is this doable?
Hi - I have a workbook with 13 sheets. Each sheet has a table which tracks weekly data. Each week I manually add a new row to the top of the table for the newest weeks data and update the formatting and formula in the new row, for each sheet. I then manually update formulas about the table which tracks MIN, MAX, SUM and AVG. Is it possible to automate these steps for all 13 sheets?
Hello! Very informative video there. I had a query about adding the number of calls made by different people on 30 days of a month, each day being represented as a separate sheet. The sum of the calls, I want in a summary sheet. Is there any function I can use? Your help will be greatly appreciated. Thanks
Hellol! This worked but when I try to sort by date it keeps the data grouped to what wheetit came from. Is there a way to combine the date across multiple tabs and sort it by a variable where it will all mix together?
I'm using this formula: =FILTER({U1:X \ AA1:AD} ; NOT(ISBLANK({ U1:U\ AA1:AA}))) and its throwing me Value ERROR: Filter Range must be a single row or a single column. What am i doing wrong? :(
I have absolutely SCOURED the internet looking for this answer. You explained it so simply - THANK YOU SO MUCH.
Learned a lot... a great presentation with practical scenarios...
Great to hear it. Thank you.
Hi there! This is as super useful video, thank you!
I have a question: imagine the 3 source sheet (january, february, march) have slightly different column layout. The columns may be in a different order or one sheet have some additional columns compared to the others. How in that case would you concatenate the three sheets? I've managed to do something that works by combining FILTER (the first 10 columns are the same for every sheets) and IF/VLOOKUP (to fill in the 20 following columns that are in different order).
Is there a more efficient way to do this?
I can't just change the source sheets because they are auto-updated export from a document management system
Great Video thanks... I'd like to do something similar except I'd like to add another column in the appended sheet (Qtr1) that would indicate where the data came from, ( ideally sourced from a cell within the original tabs). In your example it would populate the new column with the values "January", "February" and "March" for each row/record. Is that possible? Also can you say which is the fastest/most efficient to use in terms of processing time?
Thank you for sharing this valuable formula and for your clear explanation!
This is a great video! Found more like it but none of them allows the tabs to be deleted. Does anyone know how or if that is possible? I have a years worth of info I want combined into one year summary but not the individual months anymore. Do I just hide them?
Thanks for this I have learnt so much but am hoping I can call on your expertise now to take my master/combined sheet to the next level.
I have created a filter view to show my permanent and casuals and now need to add in the master/combined sheet additional information to be retained when new data is added to one of the sheets that mergers into the master/combined.
Is this doable?
Hi - I have a workbook with 13 sheets. Each sheet has a table which tracks weekly data. Each week I manually add a new row to the top of the table for the newest weeks data and update the formatting and formula in the new row, for each sheet. I then manually update formulas about the table which tracks MIN, MAX, SUM and AVG. Is it possible to automate these steps for all 13 sheets?
Probably. You could look into using Google APPS Script for that.
Hello! Very informative video there. I had a query about adding the number of calls made by different people on 30 days of a month, each day being represented as a separate sheet. The sum of the calls, I want in a summary sheet. Is there any function I can use? Your help will be greatly appreciated. Thanks
This is brilliant! Thankyou so much!
This is awesome and was so helpful. Thank you.
You're so welcome!
Thank you so much for this video!
thank you very much, very useful.
what if you have 100 tables? do I have to use the same formula as shown in the video.
Hellol! This worked but when I try to sort by date it keeps the data grouped to what wheetit came from. Is there a way to combine the date across multiple tabs and sort it by a variable where it will all mix together?
Yeah, probably with the QUERY function. I'd take a look at the documentation for that one. It's very flexible.
@@ProlificOaktree Hello and thank yiu for your response. I've tried that as well but it still sorts them by date but each tab stays grouped together
Thanks a lot!
I'm using this formula:
=FILTER({U1:X \ AA1:AD} ; NOT(ISBLANK({ U1:U\ AA1:AA})))
and its throwing me Value ERROR: Filter Range must be a single row or a single column. What am i doing wrong? :(
The Unique function is not working for me. the Sort did but the unique keep saying error
mine too
Hi. I have a question regarding Pivot tables. How can I contact you?
Thanks for asking but I don't do consulting.
@@ProlificOaktree No worries, I managed to figure it out. You're awesome. Keep inspiring!!
Damn dude, thank you!
I really want to kiss you now lol
That's a natural reaction to a spreadsheet video.