📚NEW Excel Functions - VSTACK and HSTACK! 🙌🏻

Recently Microsoft released a set of new functions in Excel to help us manipulate data. These functions are currently only available in Excel for Microsoft 365.
In this video, we are going to take a look at two of them: VSTACK and HSTACK.
VSTACK stands for vertical stack. It allows us to stack data from different cell ranges and sheet on top of each other. HSTACK does the same except it stacks the data horizontally across the page.
These functions are not only useful for combining multiple datasets quickly, but they are completely dynamic and can be combined with other functions to make them more powerful.
#excel #exceltutorial #vstack #hstack
🔗LINKS to Related Videos
GROUP Excel data into Custom Buckets
• 🪣GROUP Excel Data in t...
Create an Expiry Alert using Nested IF Statements
• 🪺Create an Expiry Aler...
5 Ways to COUNT in Excel
• 🖐️5 Ways to COUNT in E...
🤝Let's CONNECT on social:
➡️TikTok: / cellmates_
➡️Instagram: / cellmatestr. .
➡️LinkedIn: / deborahas. .
➡️Twitter: / cellmates_
➡️Facebook: / cellmates

[@BenDieselBasicAutomotive]

....this topic will revolutionize the drafting of reports..... Thanks..... so much...

[@BenDieselBasicAutomotive]

Thank you very much for this very useful topic!.... I've been looking for this topic..... Now I can consolidate my monthly WORKSHEET. More power to you, Mam!..... GOD BLESS....

[@BenDieselBasicAutomotive]

I can now simplify my tasks in the office.... Consolidating my monthly reports is now basic to me.... Added innovation and productivity in our performance. You made our office tasks easier and sytematic.

[@hi_vishy]

Those who haven't seen your videos are definitely missing something.

[@angelv1393]

thank you so much

[@AL-Yaqeen]

what a tremendous video , thanks in advance

[@cellmatestraining]

You’re welcome!

[@robparker1625]

Without testing this, I presume this will work with tables and named ranges?

[@cellmatestraining]

Correct, yes :)

[@vivekpatil3834]

Is there a way to create headers for Hstack or we do cut paste

[@cellmatestraining]

Select all the worksheets and then type the headers and they will show on all selected worksheets.

[@vivekpatil3834]

@@cellmatestraining thanks you could have explained array function also here

[@cellmatestraining]

@@vivekpatil3834 lol. My KZbin videos are re-purposed TikTok videos which is the main platform I post on. TikTok videos have a limit of 10 mins.

[@danieltemelkovski9828]

For the example in the video, =HSTACK(IF(ISBLANK(A3:B7)=TRUE,"Sales",A3:B7,IF(ISBLANK(A9:B13)=TRUE,"Sales",A9:B13)) this will give you the name of the continent and Sales as headers. (The formula I wrote only does Europe and Asia; expand the formula if you want the rest.)