The function wrapcols takes a range of cells and place them into a 2-dimensional array by column.

Each column is formed by the count specified in the argument.

Syntax:

=Wrapcols(range to wrap, number of values per column, value to pad-with)

Range to wrap. the vector or reference of cells to wrap

Number of values per column. is the max number of values defined per column

Value to pad-with. This value will be use to pad in case of uneven columns, the default is #N/A