How to Use VSTACK HSTACK Function in Excel #shorts

You're going to love the new VSTACK & HSTACK functions in Microsoft Excel! With these power functions you can append your data together. VSTACK dynamically combines arrays into a single vertical array while HSTACK combines them horizontally. In this video I'll show you how it works.

Requires Microsoft 365. The TAKE function will not be available in Excel 2021 and earlier versions.

🚩Let’s connect on social:

👉 This description contains affiliate links, which means at no additional cost to you, we will receive a small commission if you make a purchase using the links. This helps support the channel and allows us to continue to make videos like this. Thank you for your support!

#Excel

[Jorge-uirh]

Thanks a lot, this formula will help me a lot in my multiples Bill of Materials

[Dhiyaneshwar_Vlogger_]

Quite an Excellent Leila🤠
Each video teaches me a lot...
Keep updating your Excel tips and tricks...

[MrLeonGros]

Again, another life hack for me at work!

[naomiomi]

Wish I saw this vid this time last week 😫

[sachinrv]

VSTACK is great. You can make one array of many arrays and then use other functions of office 365

[pauldaniel]

Thank you for your valuable informations

[suhendrikhendrik]

Why when I add the new data, the table doesn't automatically expanded? I have converted my data into tablet by pressing ctrl + t

[jadedunia]

Nice 👍🏾 no more need of powerquery to append files then ?

[hereg]

Then combine with sort, filter and choosecols?

[Kiyoshi_]

It'll be awhile before you can use these at work (enterprise Office), but best to get ahead of the curve 😀

[asddsa]

This is nice and all, but unavailable to non-Insider users.

[dvannest]

If I need to set up two vstacks in the same column, can I put the second formula right under the first or do I need to "guess" the number of rows the first array will be and enter the formula there?

[hansklein]

I don't see the pinned comment, though I opened the video from my youtube history, to see it on whole screen.

[n_utd]

what if I just copy and paste the tables?

[GScrubb]

Surely your worth more than 30k a year with all your knowledge? 😊