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

#excel #functions #data