Lookup & Reference Function - WRAPROWS

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

The video shows the WRAPROWS function in use.

The written calculation is below:

=WRAPROWS(B3:D3,2,"No Data")

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

2 is the number of columns 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.