Exciting NEW Excel Functions for Compiling Data - VSTACK & HSTACK!

The new VSTACK and HSTACK functions work to combine arrays arranged vertically (VSTACK) or horizontally (HSTACK) into a new single array.

0:00 Excel VSTACK and HSTACK Functions
0:43 Basic VSTACK Example
1:01 VSTACK with Headers
1:29 VSTACK Sorted Data with Headers
2:07 Handling VSTACK Errors
2:42 VSTACK Unique Rows
3:05 VSTACK 3D Range
4:33 VSTACK Ignore Empty Rows
5:32 VSTACK Filtered by Criteria
6:18 HSTACK
7:12 VSTACK 3D Reference Limitations

[vijayarjunwadkar]

Mynda, you have a knack to explain with right examples and this video is no exception! Thank you for helping us learn so much about Excel and related tools, especially the new features! Great work!

[sachinrv]

Hi Mynda, I just love to watch your videos on Excel bcoz you keep things simple and explain wonderfully.

[TP]

I liked how you went straight to point, no additional/unnecessary talking, and no music. Very clearly articulating how the functions work, with their different scenarios. Thank you !!!

[a.achirou]

Thank you, Mynda for this outstanding presentation. That's impressive the way you introduce effortless those functions!!

[hectorbello]

Thanks for sharing; incredible how little I know of excel functions, and each time I watch one of your videos I get the feeling is a never ending endeavor.

[aiasaiascon]

Borrowed by @VijayArjunwadkar but TRUE - Mynda, you have a knack to explain with right examples and this video is no exception! Thank you for helping us learn so much about Excel and related tools, especially the new features! Great work!

[IvanCortinas_ES]

Powerful tutorial Mynda. As always, a brilliant explanation. Thank you very much!

[mohammadj.shamim]

Thank you so much Excel sensei. You have really widened our view and capabilities of using Excel. Much appreciated and thank you very much. 😊.

[stevevuoso]

This channel is a straight up goldmine.

[michaeldavenport]

Outstanding! You have just saved me SO MUCH time. Thank you!

[frozenade]

Combining xlookup with a filtered vstack is quite exciting, thank you for a great video!

[hussainakhtar]

Amazing Video.. Can't compare your grip on excel functions... your explanation is very smooth... very impressive

[josepepe]

I always enjoy your videos. Direct to the point and very good explained.

[darrylmorgan]

Hi Mynda!Great Tutorial/Demonstration Of These Cool New Functions...Thank You :)

[iziaurrahman]

As always your videos are very useful. Thanks a lot for sharing this.

[bradleybeauclair]

I have these new formulas now. Previously, I had Microsoft 365 and Business (2x Microsoft accounts). I had Windows 10 Pro and Windows 11 Pro Preview on another PC. I was a Microsoft Office insider on both PCs and tried everything to get these new formulas somewhere. Well, now I have Windows and 11 Pro on a new PC and after joining Office insider- they worked after the update.

[erikguzik]

At around the 5:45 mark you want to include the headers, if the headers are the same as the tables you are stacking use HSTACK to get the header row then stack it on top of the tables
like this (if using tables, its easier) =VSTACK(HSTACK(Table1[#Headers]), VSTACK(Table1, Table2, Table3))

[sachin.tandon]

Great tutorial! Very powerful time-saving functions!

[tmb]

Thanks for the video as always. Really like your straightforward style.

It's nice to have the flexibility these new functions provide but I have to admit I'm struggling to think of situations where I'd use them over Power Query. Maybe for some really quick and dirty stuff!

[Checkm]

My use case is pretty straightforward. Basically just data entry. I get a list of training that need to be completed. I look up who can teach and who needs trained, the managers involved, start times, and durations.
When I started, we had to look everything up, every time. I've been working on fetching data from QuickSight, but recent security changes prevent me from doing it directly. Back to square one on automating myself out of a job, lol