Simple but useful function to transform a multi-column arrayinto a single-column.

It’s completly FREE!

Just use:



and stack your columns instantly wherever you need it in your spreadsheet. Without altering the initial array.

Remove blank cells


=STACKARRAY(ref_to_your_array, TRUE)

Stack row by row instead of column by column


=STACKARRAY(ref_to_your_array, , TRUE)

To merge an array with unique values only, use



To sort the resulting column, use