Lookup & Reference Function - VSTACK

Combining two lots of data together used to be quite complicated, but not anymore now VSTACK exists!

The video shows the VSTACK function in use.

The written calculation is below:

=VSTACK(B3:D8,B11:D16)

​Our example is a combination of two arrays, B2:D8 and B11:D16 but you can add as many as you need.

The function will combine these arrays into a single data set.