The VSTACK Function | Dynamic Arrays | Stacking variable data into a single array
14 new functions were released in Excel recently. Today, we dig into the what's what of the VSTACK function. It allows you to take separate datasets and assemble them such that they behave as a single dataset.
0:00 Intro
1:03 Explanation of the challenge
2:21 Demo of my solution
3:54 Building the solution
9:44 Outro
#VSTA
#DynamicArrays
#TopTen
For a list of my Excel courses at Lynda/LinkedIn:
/ oz-du-soleil
There are courses on Power Query, Good spreadsheet habits, and a weekly Excel challenge that comes out every Friday.
Website: http://ozdusoleil.com
My book: Guerrilla Data Analysis 2nd Edition
http://www.amazon.com/Guerrilla-Analy...
My old blog: http://datascopic.net/blog-2-2