Lookup & Reference Function - HSTACK

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

The video shows the HSTACK function in use.

The written calculation is below:

=HSTACK(C2:H4,C6:H8)

​Our example is a combination of two arrays, C2:H4 and C6:H8 but you can add as many as you need.

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