Lookup & Reference Function - WRAPCOLS

Take columns of data and rearrange them into a brand-new array, based on a specified height, or the number of rows.

The video shows the WRAPCOLS function in use.

The written calculation is below:

=WRAPCOLS(B3:B8,2,"No Data")

​In this example, B3:B8 is the array we want to transform into another form.

2 is the number of rows we want to wrap the selected data into.

"No Data" is the text string we want to display if any cells in our new array result in an error message.