VSTACK Excel - Quickly Combine Data from Multiple Sheets (Excel Noob Vs Pro)

[@LeilaGharani]

Grab the file I used in the video from here 👉 pages.xelplus.com/vstack-file

[@IGNACEGIRUKUBONYE]

Hello Leila! Thanks a million for your teaching materials, they are helpful. I have a question: After combining sheets with VSTACK, I can't turn the data into an Excel Table. Why is it so? What can I do to keep the data Dynamic? Thank you for your feedback!

[@Alkamanojofficial]

Whast about version of Excel?

[@RenierWessels]

This was awesome Leila. Being able to showcase all of that in under 7 minutes is pretty amazing. I struggle with keeping my videos short myself. The production value of your content is amazing. Well done.

[@LeilaGharani]

Thank you Renier. You have great videos on your channel.

[@RenierWessels]

@@LeilaGharani thank you. I appreciate your reply!! Keep up the great work.

[@truthByFire]

This channel is fantastic. Great content!

[@dheerajy2202]

@@LeilaGharani big 🧢

[@Idiot123009]

@@LeilaGharani Leila Gharani is always amazing. Excellent and precise on topic. Excellently explained. Always pray for you.

[@SamOlliver]

Thanks Leila, your videos never cease to be useful and informative! 😀

[@LeilaGharani]

Thank you, Sam!

[@texian2112]

Why isn’t there a love button? As always thanks for this valuable productivity hack. Keep doing what you do Leila. Love this and all your other posts.

[@cruzinsweetsntreats]

There is from the content creator, such as Leila, but not from us, as I too, would like to respond as such on numerous others. 🤟💌😍

[@ashutoshaurum]

Whenever I KZbin a problem on Excel and it's your video, I know it is the best of the lot. Thanks for the wonderful explanation!.

[@roderickmose4691]

"Hold my coffee".......just gotta love the lady! Excellent and creative as always. Well done again, Leila!

[@mamachugh1125]

This is fabulous Leila! I always appreciate your tutorials. Short and sweet, as always.

[@LeilaGharani]

Thank you so much!

[@tommyriddley8129]

I have been following you and it has resulted in me signing up for your courses on Udemy. Although I have to take several attempts at the lessons it is great using your practice files so I can concentrate on developing my understanding of the functions. Thanks for sharing your knowledge.

[@Rogue-productionsCoUk]

This totally fits my learning style! Great to see the problem and have the solution stepped through. Excellent demo of 3 function in 7 minutes!!

[@LeilaGharani]

Thanks for the feedback! Happy to hear that.

[@chh8860]

VSTACK??? ... I'm speechless ... another stunning display of Excel mastery ... Some people look forward to Friday's ... I look forward to Thursdays ... w/Leila ... 😍 PS " ... we just had to switch things up for a change ... let me know what you thought about it ..." 😞 ... 🥱 ... 😴 ...

[@LeilaGharani]

Thank you for still looking forward to Thursdays! Even after all this time.

[@pdrg]

Then the Regional Manager arrived and didn't even look at it...

[@magnushultgrenhtc]

My thoughts exactly. "We're running two minutes late and will have to cut the presentation."

[@soft.learning]

It happens sometime

[@usmanahmed5854]

😂

[@LetsCOLORup]

Lol

[@amoorinet..]

Far from the main purpose of reports which is documentation I don't know what the size of the company you work for, but as a professional management approach, top position people prefer short reports. An example in the field of construction in which I work is that area managers are interested in achieving the Milestone without details, and project managers are interested in achieving a number of activities without details. And construction managers are the ones who care about this huge amount of reports.

[@Hey_Dave]

Love the switch-up!! Amazing! I always learn something new from your videos.

[@igortorrealba]

Looooove this format Layla! I encourage you to consider doing more like this!!!

[@rob4canada]

Loved the new video style and explanation of VSTACK and how it could be used in a real world example.

[@Cappurnikus]

Very cool function. Thanks for sharing! I recently solved this same scenario but with VBA. It was a very small loop but also considered the last row of each sheet to ensure there will never be missed info. Thanks again!

[@michebernier5298]

Thank you so much for this video, it was great reminder that formulas can be built with main intent, then sub requests added in as they were requested, all too often many of us build the formula from the beginning to the end, and forget we accomplish one goal, then add another goal, and so forth. Example, delivery and content was fantastic -- Thank you !

[@RichardJones73]

You've excelled yourself again Leila, Queen of Excel

[@efs83dws]

Very good presentation. You are the best on KZbin for presenting Excel functions and features.

[@izabelalolea1235]

Mulțumim!

[@andrewcharlesmoss]

Great acting skills, Leila!

[@loganwebb1338]

I loved this! I am relatively novice with excel but I've learned a massive amount from you. I found the other day that I did not know how to stack data without manual copy pasting and have been trying to figure that out for nearly a month. Thank you for showing this vstack formula!

[@abdulsaidmkamara7305]

Leila Gharani !!! She does it again Thank you !! I will be implementing this soon, You have taken by the hand from a below average excel user to Finance Executive level execution in a few months. You are one of the best things to happen to my career.

[@LeilaGharani]

Thank you Abdul! You've done the hard work. I'm glad to be a part of that.

[@chrism9037]

Thanks Leila! I still don''t have VSTACK but can't wait to get this and other new functions.

[@officialpreside10]

Wow. You never disappoint. Weldone Ma'am

[@nathanmclauchlan5148]

Wow. Amazing. Thanks so much, you made it rather easy to combine data from multiple sheets, remove blank rows and sort the data

[@NoTengoIlusiones]

Love the video. Sense of humor and useful as always . A big and fat like !

[@luisfeps]

Thanks from Brazil. Amazing videos with so dynamic teaching techniques.

[@spacedudey2k]

Fantastic tutorial. And I think I will use this on a project I’m working on currently. Thank you, Leila.

[@almac6994]

Thanks!

[@LeilaGharani]

Thank you Alma!

[@kenhappich9032]

As always your presentations are so extremely informative and I love how add the humorous theatrical drama. Your presentations are definitely polished !!!

[@michaellucas7177]

Wish I could thumbs-up this like ten times!!!!

[@dagnabit27851]

This is amazing! Side note: I'm the noob who didn't know you could drag and drop tabs from a different file so I learned quite a bit in this video.

[@LeilaGharani]

Glad you liked it :)

[@thierryhoornaert9950]

Thank you, Leila. This is great stuff and a real time saver!

[@PurplePegasus2531]

THANK YOU SO MUCH!! I was literally just having this issue at work and now I can use this in real time! You're so great at making excel accessible! You're making me a superstar at work

[@Cdaddyx1212]

Honestly I always thought I was quite advanced in Excel but it is amazing how you overlook small things that can actually be very useful. Thank you so much Leila for your videos and especially how you go through the formulas in a step by step way so it is easy enough for me to keep up. I learned more from you than the official advanced classroom training I had.

[@LeilaGharani]

Thank you for the kind feedback!

[@MiRofek]

Great tutorial Leila (as always)!

[@snicho]

Ah, it's a beautiful thing! A great practical example. A good use of combining functions. Well presented. And the format works well too. :)

[@cdyard1]

Great demonstration of how 3 functions could be used together. And I love the way you show this. ;-)

[@hectorbrac100]

This is amazing Leila! I wished I had seen your video a few months ago when I had to figure this out on my own by try and error yet though I came to the same set of formulas I realized that doing so in Power query was less messier and more customizable. It's still great to know that the same result can be achieved in different ways

[@JeremyMcMahan]

Fun video! The part about sorting with two columns and the curly braces for ASC/DESC was gold!

[@sarahmclin2434]

My boss suggested I check out your channel to learn some of the newer excel features. I am so glad he did! I loved this video.

[@catatoa]

Thanks

[@LeilaGharani]

Thank you!

[@ujjwaldeo6770]

OMG😲 I had no clue about this before today. In actual tasks on our jobs, things would be so much easier...just using this, esp. the VSTACK....simply wow👌. Thanks Leila👍🏻

[@LeilaGharani]

You are so welcome!

[@fernsehdesign]

I like the voice of the Noob especially. Cute realistic drama that you created there. Looking forward to the next episode.

[@a.achirou6547]

This is fantastic Leila. That caught my attention all along !! Thank you.

[@camnear]

Crazy helpful. Thank you!

[@Ticky66MN]

Dang, that was an awesome video. Love the style and the resulting education...very impressive. Thank you.

[@rasyidihramsyah7992]

Short, brief and straight to the point, no reason to not subscribe to this brilliant channel

[@LeilaGharani]

Thanks! Glad to have you aboard :)

[@user-dh4bz7fk9z]

You deserve way more subscribers

[@HANSMKAMP]

I love that!! Both the way the video is made, and its contents. Also the strength of VSTACK, FILTER and SORT!

[@gurudattkeshav]

This is the best one for me so far! Thanks Leila

[@carlosd.villanuevaa.3833]

Great video, Leila! It helped us, the crowd, better understand these functions that, otherwise, can be difficult to explain in general terms. Thank you so much for putting this content!

[@AmanChamoliVlogss]

Great Leila !! i have no clue about this function availability so far....it surely gonna help in filing my GB certification in my Organisation ❤️ more power to u and happy learning together 💕

[@hussainakhtar1094]

This is just a master blaster... I love using these tricks, playing around, and doing analysis with data. The beauty of the array functions is that the file size does not increase significantly.. Thank you Laila awesome stuff.

[@LeilaGharani]

Glad you enjoy it!

[@hussainakhtar1094]

@@LeilaGharani I have used these on inventory sheets and it worked awesome

[@drag0nblight]

I have learned a lot from this channel. I am actually using some of them for my sideline gig. No more looking up on a list on paper, just Excel.

[@readingreddit8499]

Best format yet. Keep it up.

[@sonialorenzo9223]

Love your instructions, short and clear.

[@jamesgriffin773]

Thank you for this heads up. This is a function I really want. For a long time iferror was the life changing function. Sumifs came along. Then the dynamic arrays improved my life. This will solve so many questions from auditors.

[@superohitupadhyay]

I feel superman among my colleagues, I have gone through all your videos on UDEMY as well as KZbin, many thanks for making our job easier, more power to you, and about your acting style in this video, since your content is so informative you don’t need it, however it’s making video more interesting.. Thanks (your follower from India)..

[@pravinr197]

The purpose of VStack function in excel is beautifully explained. The purpose is to combine different worksheet data into one table in a dynamic way.

[@pwells2389]

Really enjoyed your helium voice for the newbie :) Great info too. I've been using Excel for ages and didn't know about the 3D worksheet referencing (I thought that was dead with Lotus 123) or the { bracket feature. Many thanks.

[@ivanlai4611]

Awesome video, super helpful! And the different format makes it interesting!

[@thenotidevil]

It was just awesome as all your videos. Thanks for sharing and guiding us with all this knowledge.

[@LeilaGharani]

My pleasure!

[@abubakarothman6386]

Mashallah Leila. You are the real deal in town.

[@mattschoular8844]

Thanks Leila...The video format was good. It explained a hypothetical real world example nicely.

[@AmitRoy-om3tp]

Awesome video! It helped me consolidate the data from multiple sheets. Great, Leila!

[@JettingChen]

As always, you’re a lifesaver.

[@voiceofsoul7865]

Leila, your videos are as beautiful as you are. I am getting much knowledge from your videos, and your teaching style is also awesome.

[@davidjones5319]

Awesome example with multiple useful functions

[@DorothyN]

Love this. Very engaging and informative.

[@tianyi05]

Finally Excel gets this function, Lotus123 had it back in the early 1990's, except sheets in Lotus didn't have to be identically laid out, columns in sheets could be in any order and some sheets could have extra columns, also could add rows to individual sheets as definition of the array was dynamic.

[@itsRohitJain]

maestro where have you been all my life. Just wonderfully explained

[@izzatkiswani]

The Queen Of Excel 🌹🌹🌹

[@Rice0987]

And this formula is too interesting, so surely i'll try it tomorrow! THANKS Leila! :)

[@dvboy]

This is a game changer for me, learning how to vstack and filter. Thank you!

[@javer11]

Leila you saved me again! ❤ Thank you. Will find some time to study your power query videos soon, for now, this is all that I needed😘 God bless you❤️

[@truthByFire]

This channel is fantastic. Great content!

[@riansyahsumajaya]

My goodness this is why i subcribed to you. Excellent demonstration to show when this type of formulas will be used. Thanks Leila for these types of videos, really bring inspirations.

[@LeilaGharani]

Thank you Riansyah! I'm glad to hear that.

[@isamjafar3640]

Wow! I didn't realise yo can do this; it will save me so much time at work! Thank you for sharing Leila.

[@lucasb409]

I have been struggling with using the filter function wrapped on VSTACK until I noticed something. I MISSED the fact your condition was for only 1 column, not the whole row. My Value# error is gone and it works! My project is saved. Thank you!

[@GenNextAnalyst]

solution-based presentation! Very useful! Thanks Leila

[@DinoDelight]

Another great explanation, im still waiting for vstack. I did not know you can drag and drop a tab from another workbook....that's gonna save me a massive amount of time

[@deinbleiz]

Thanks Leila. This is pure gold.

[@LeilaGharani]

Glad you think so!

[@rodrigodiaz1558]

I knew there was some way more simple that the index formula stuff that honestly make my head hurt, THANKS LEILA!!!

[@CameronWilson-m5f]

I've spent all day trying to figure this out, what a massive massive help!!! Thank you so much.

[@LeilaGharani]

Happy to help!

[@zolnog]

Informative and entertaining. Thanks, Leila, you make it fun.

[@Zomaar54]

You deserve an Emmy Award!

[@ruthngmj]

Can't wait to use this new function!!!! 🤩

[@algriff21]

I've been looking to up my macro & VBA and this video has done the job! Also, just clicked to be a subscriber. Looking forward to browsing your catalog of videos.

[@michaelsiggers4109]

Superb video with so many features. Plenty of information I can use and adapt. Thankyou.

[@Bill_Woo]

Tip, freeze header rows. The sooner you do that in the process, the more you'll benefit. I know Leila knows that and surely she's covered it in other videos, but it's hugely useful for what she does on this one.

[@michaellucas7177]

Thank Woo!

[@cruzinsweetsntreats]

What's the overall benefit per your strong suggestion to freezing the header rows?

[@Bill_Woo]

@@cruzinsweetsntreats When you have more than a screenful of data you then always immediately see/know which column you're operating on. Bonus, as Leila smartly uses keyboard instead of mouse in many situations (because it's faster, more accurate, and allows undistracted visual focus), control home stope at the top of the data instead of top of the worksheet (though some may not find that to be an advantage).

[@cruzinsweetsntreats]

@@Bill_Woo that's what I realized moments later, as old-skool, compared to converting a range to a table, which then the header row is automatically programmed to do just that, show at the top when scrolling down. 🤫👍😁 I've now got mine to include a conditionally formatted group of columns that are calculating my mileage, just outside the vstack, yet in my Pivot Table range for use. 👍

[@cruzinsweetsntreats]

@@Bill_Woo I've done split screen before, but wasn't putting the 2 together. Though in searching, if I desired, I found the proper method of adding the table header on each page, for the same reason, continuity of the data.

[@shelleygower4748]

Brilliant, you explain things so perfectly.

[@kimbereleybrown9449]

Thank you! This was so helpful and easy to understand.

[@amagdenovski]

Incredibly helpful!

[@ezewong290]

This is amazing, I've been doing filter functions within the vstack and not the other way around. ALSO, 3d array... amazing exceptionally informative. Thank you

[@BEDSTUYKEV31]

2 snaps up. Thank you! I needed a workaround from PowerQuery since I had to consolidate worksheets in non-table format

[@loudodson]

You are an absolutely wonderful person! This was a perfectly timed video. You solved a problem I have been working on for the last 2 days. Thanks for the great work and insights.

[@LeilaGharani]

Glad it was helpful!

[@behnazrezaieortakand2360]

You are brilliant Leila

[@hiteshbhatia787]

Big fan of urs....as always u bring the solution of problems with dynamic formulas and building dynamic environment in Excel....

[@ayaazthaliph2108]

Didnt even know this was possible, and you make it so easy!

[@bellondayako4162]

Loved the way tutorial was presented.