Pivot Table from Multiple Sheets - Google Sheets

[@jackie7486]

I only wanted to learn one thing but ended up learning a whole other bunch of things from you. THANK YOU

[@Limesh]

Same here

[@riffrff]

my thought exactly :)

[@alexandervalera2334]

How does this piece of artwork only have 400 likes?!?! Super help. Hope it goes viral. Thank you.

[@vmelove]

Thank you! This solved an issue I've been dealing with for quite a while. I can't tell you how much time this will save me!

[@prestofam6148]

I've been looking for a guide on how to combined sheets into one and this is the most straightforward way to do it! You even give extra by suggesting options! You're amazing!! I'll subscribe to your channel and watch your other videos so I can learn more. Thankyou man!

[@AntonRah]

Straight to the point without all the jibber Jabba. Informative and just what I needed, Subscribed. Thanks

[@aaronarnold2250]

Dude, you are crystal clear in the way you presented this. Thanks so much. You saved my Saturday.

[@alimahamed1151]

This is exactly what I was looking for. I wanted my pivot table to auto update and it wasn't doing that. I saw people using VBA to do that in Excel spreadsheets and I thought I had to use Google APP Script to make it work. I was overthinking the problem.Thank you very much. Subscribed!

[@ExcelGoogleSheets]

You don't need VBA to do this in Excel.

[@mmorrissette27]

This was very helpful. Thank you!

[@tanmayjoshi3499]

you just saved tons of my time. idc abt grammar, i'm so happy rn.

[@joz0000]

Thankyou from Italy! clear, clever and simply!

[@kerenbanget1]

This is life savior when I need it. Thanks for the video.

[@ExcelGoogleSheets]

Glad to hear it!

[@jakeabivaofficial]

Easy to understand and follow. Thank you for sharing

[@ItsTheGLife]

This is awesome!! I learned a lot more than I intended. Easy to follow and understand. Straight and direct to the point. Thank you so much!! You rock!!

[@CrooZF]

❤ Easy to understand and follow. Thank you for sharing

[@ExcelGoogleSheets]

Glad it was helpful!

[@SamuelAwd]

I really cannot thank you enough, you made it really easy and you helped a lot in my work !!!! Thank youuuuuu

[@viewer2759]

Thank you for the helpful video and instructions! I wonder if you really need the SORT function, since the "combined" sheet is being hidden, and the Filter in the Pivot Table is filtering out the blanks anyway. A minor point. Thank you once again - greatly appreciated.

[@oleksandrhryshko6253]

Thank you very much for the detailed and in-depth knowledge you sharing with the community.

[@ExcelGoogleSheets]

Thanks You!

[@Scalp269]

Awesome !!!!! Just what I was looking for. THANKS !!!!!

[@SteveSiegel]

This is exactly what I needed! Thank you!!

[@ExcelGoogleSheets]

:)

[@euphoricgaurav]

Thanks for such an informative video...Really Helpful...

[@elengaboyan1997]

Thank you, this is super useful! Is it possible to do the same thing but when the source files are not tabs, but a different file?

[@steve_greenblatt]

This video is awesome. Thank you! I have a question though. If one of my tabs is missing one of the columns that I'm trying to combine how can I insert a "default" constant for that missing data?

[@maureengreen5087]

Excellent video. Went above and beyond my expectations. Thank you!

[@ExcelGoogleSheets]

🙂

[@ThuTran-pv3zv]

Good video! I like how you show different ways that users might do and point out which is the right way to get the correct data. You earned a subscriber today!

[@gm4sh]

thank you, you're saving my day!

[@maciejkaczmarek9318]

really amazing video, I got exactly what I was looking for! subscribed to watch more videos

[@stuartmclaughlin2956]

Excellent presentation (again). Methodical, logical and effective. 😀

[@beltrandigital]

This was great, thank you!

[@СергейОнищенко-ъ3ж]

Awesome lesson!

[@Benjaofficial]

You're amazing. Thank you

Wow this is all I was looking for and more! What a great, simple, but thorough explanation. Subscribed.

[@Patryc]

also bloody brilliant mate

[@immahotpepper]

great tutorial - super easy to follow along and understand the concept

[@ExcelGoogleSheets]

Great to hear!

[@judenarsingh7347]

This helped me sort my Data, Thank you for your Help :)

[@philiphorton1661]

That was an Amazing tutorial, very easy to understand. Thank you for taking the time to make it.

[@HafizAzmi]

Awesome! Thanks for your video, ultra informative.

[@jagdish1o1]

Awesome content, subscribed!

[@elengaboyan1997]

Can we perform two-way editing? i.e. edit in the combined table and it automatically shows in source file?

[@avishkaweerathunga2057]

Thanks. It is very usefull

[@daviddoget1773]

You all are awesome! Thank you for making these videos :)

[@bangjamz]

12:33, is there any automated way such as excel power query ? yeah i know, google sheets doesn't have power query, but i just hope there is one. because i want to combine multiple sheets with so many different column, so it's hard to sort same column one by one.

[@Absolukely]

Wow this video was just what I needed and more!!!

[@ExcelGoogleSheets]

:)

[@indrajitbhattacharjee9672]

Very useful information thanks

[@rafsan_jane]

In this pivot playlist which video should we watch first? Thanks a lot for making helpful videos

[@vishaljagtap8996]

Very helpful thanks for sharing

[@ExcelGoogleSheets]

👍

[@RFAbenAthar]

This made my day!

[@ArsenalTirePerformanceTech]

Wonderful video!!! Thumbs up!!! Very well explained!

[@marufaakter8914]

Hi. The tutorial is awesome. Thanks, it is really helpful. Just wanted to learn one more thing that's if I want to see the subtotal by the month how can I do that? Please let me know. Thanks.

[@ExcelGoogleSheets]

Right click on dates in the pivot table and Create Group.

[@greenolution]

very useful !

[@KieranDoyle]

great video, thanks a lot.

[@ExcelGoogleSheets]

Glad you liked it!

[@ElectroKalEl]

Very useful, thanks

[@Patryc]

can you upload a sample completed document

[@uttampawalekar4765]

Can we make pivot from different spreadsheet (workbook) ?

[@arfanrasheed2716]

Excellent video you have made. Thank you. I am giving you a like and subscribing to your channel. I hope you have video on your channel about pivot table formatting, so that it looks beautiful and easy to understand.

[@gyorgyilaszlo6513]

Very useful

[@Vishnu-zo1yc]

When i use SORT function, it's came Blanks in Top, not bottom. Please suggest

[@shabacsain3498]

Thank You. This is so useful.

[@danijel6354]

Simple and informative, thank you so much!

[@walterpaiva719]

Your videos are awesome!

[@sra.veloce4983]

Great video! Thanks so much!

[@techshortcuts4924]

Thank you very much. It works great. I now can event add importrange to combine mutiple sheets from different files. BTW, you got a new subscriber.

[@ExcelGoogleSheets]

Excellent!

[@jessicatuifagu8087]

Hi, when I add in "=SORT( )" it only sorts the column, but not with the rows? I'm not sure what I'm doing wrong. Please help.

[@jansmits5486]

Hey thanks for the vid but it seems the coma dosent work anymore is there a new way of doing it?

[@ExcelGoogleSheets]

It does work kzbin.info/www/bejne/opvZc2WXp6imhLM

[@ginnytu6429]

Thanks for sharing! Could you please kindly share the other method to remove blank cells? Cause the sort function kinda messes up my arrangements of cells

[@ExcelGoogleSheets]

kzbin.info/www/bejne/p2nEqIGJjrOXp5Y

[@ginnytu6429]

@@ExcelGoogleSheets Thanks so much!!!

[@SreyasiChakravarty]

Thabks a ton!!

[@OliverJoshuaJacob]

this is a great resource

[@robdcradle]

FAN-ffff****in-TASTIC!! Thank you!!

[@lanternfly953]

Thank you!!

[@RaphaelValente]

wow.. this is so amazing.. thanks a lot for sharing. It really helped me a lot...

[@ManojCh-g9v]

AMAZING!!!!!

[@sajuchacko5464]

I got the error - Function ARRAY_ROW parameter 2 has mismatched row size. Expected: 3881. Actual: 997.; Can you help with this, please.?

[@gtaylor1380]

Hi, another question... please send a link from your videos to create a template. thanks

[@JBMizz]

Very helpful thank you!

[@ExcelGoogleSheets]

Glad it was helpful!

[@subjecttochangermnnt5325]

Little Update for non-Americans: Depending on the keyboard layout, you might need to use \BACKSLASH\ instead of ,comma, to specify ranges to be placed horizontally to each other. I was clawing my eyes out for a couple hours wondering why this guide just didn´t work for me, until this link gave me the answer to my issue: infoinspired.com/google-docs/spreadsheet/use-curly-brackets-to-create-arrays-in-google-sheets/

[@ExcelGoogleSheets]

You could also watch this kzbin.info/www/bejne/opvZc2WXp6imhLM

[@subjecttochangermnnt5325]

@@ExcelGoogleSheets Oooh nice, ty for showing me. googling all kinds of related word combinations never produced any viable results for me, I´m happy I already know what ! and $ usually do... I guess I could spend the rest of the Summer of ´Rona only watching your videos but there´s so much else to do. Definitely gonna bookmark your channel though :)

[@majo7474754]

Thank you!!! this worked for me too :)

[@ankitashastri4101]

Thank you so much 🙏🙏🙏🙏

[@ExcelGoogleSheets]

🙂

[@joshuamarcelo9234]

I need help, I not sure why the 2nd data range (next to the first ;) is not returning. The array {} formula only returns the 1st sheet but not the 2nd.

[@ExcelGoogleSheets]

Is it possible you just have a lot of blank rows in the middle and it seems like it's not returning it?

[@ExcelGoogleSheets]

Also, make sure you watch this kzbin.info/www/bejne/opvZc2WXp6imhLM

[@MikeCowen1]

Will you be adding this video (and the one from last week) to your 'Pivot Tables in Google Sheets - Beginner to Advanced Tutorials' playlist? I share that playlist with others as part of my employment :) Thanks!!

[@ExcelGoogleSheets]

If I find where it's done :) This new KZbin dashboard is not easy to navigate.

[@Heznic]

after inserting ={ , i tried to select the Partial 1 data, error message appears,... can please help me?

[@wctins]

I'm doing exactly the same thing in a new sheet until 2:00 of the video and after I hit ENTER, I'm getting Formula parse error. what could be? Version maybe??

[@closedlooprecycling.]

I am doing the same thing until 2:00 and it is only transferring the first tab in the array, the other info from 3 tabs is not included.

[@JohnDeir]

Very nice, Thanks. Question: could you do a tutorial on using the ampersand in various function structures like this one ( =Filter(D5:D10,B5:B10&C5:C10=F5&G5) ) that finds a value from multiple lookup values? I think there's more to all this than just this example. Again Thanks!

[@nabinfombo]

How can I combine data of multiple sheets with their respective sheet name also in a column.

[@PN5SEARCHTEAM]

how can i remove the blanks cell while using the Sort function? please help anyone?

[@walterpaiva719]

Thanks for the video man!!!

[@walterpaiva719]

This trick about condition on empty cells is so cool

[@FlyingVGibson]

this is exactly not what im looking for! in excel we can use relationship pivot table. so, how we do that in google sheets?

[@shruthitejashwani3570]

Hi, Sir We need an information google spreadsheet. If someone makes an entry there, how can we know what time it is entried (actually we need to know what time it is done) Please advise us suggetions

[@shaniecemohammed9882]

This is exactly what I was looking for, however I have tried on numerous accounts to create the array formula by your instructions and it is not working. Please help

[@ExcelGoogleSheets]

kzbin.info/www/bejne/opvZc2WXp6imhLM

[@saeedas2660]

Thank you

[@thomasdriscoll3777]

worked

[@L2JFrozenFoods]

can someone help me, I don't know why, but the video got blurry starting from the sort function explanation. Please care to share the whole formula for me on how to combine the data, thanks in advance.

[@ExcelGoogleSheets]

It's your internet connection. Click on the gear icon and switch to higher resolution.

[@L2JFrozenFoods]

@@ExcelGoogleSheets yes got it . Thank you for this easy to learn demo. what a great help!❤

[@prestigeequestrian]

Can anyone find my error? Formula is below. Data only displaying from 1st sheet, not both. columns match on both if that's relevant. ={'Task List'!A2:A,'Task List'!B2:B,'Task List'!C2:C,'Task List'!E2:E;'Tasks One Off'!A2:A,'Tasks One Off'!B2:B,'Tasks One Off'!C2:C,'Tasks One Off'!E2:E}

[@paulloup5210]

Thank u very much !!

[@alinakalganova7838]

Спасибо большое! Это гениально

[@ExcelGoogleSheets]

Thank You!

[@garycorns8128]

I keep getting an error. Will it work with data validation? "Error Array result was not expanded because it would overwrite data in C9. Invalid: Input must be a valid date

[@babykaye25]

me too

[@oozzee724]

i cant make the combined sheets, the formula of =(rowX,... comes up with #ERROR, it says formula parse error

[@ExcelGoogleSheets]

{ not (

[@oozzee724]

@@ExcelGoogleSheets thanks

[@vincents1087]

What about multiple workbooks?

[@ExcelGoogleSheets]

kzbin.info/www/bejne/p6TUm4iud8iad9U

[@andreasmeyer280]

A lot better way to create the combined tab: use the formula query()

[@ArapovOleg]

how to use it? I tried but it doesn't work

[@iOne89]

How to create pivot with multiple file?

[@ExcelGoogleSheets]

kzbin.info/www/bejne/p6TUm4iud8iad9U

[@mariwasafg7009]

mine has return syntax error ?

[@ExcelGoogleSheets]

kzbin.info/www/bejne/opvZc2WXp6imhLM

[@richiotz]

I love you.

[@ChristopherWanha]

Summary: Helper Column