The WRAPROWS function in Excel converts a row or column of values into a two-dimensional array.

• Select the cell where you want the new table to appear
• In the formula bar, type =WRAPROWS(
• Select the range of cells to wrap
• Add a comma and enter the number of columns per row
• Close the function with a parenthesis and press Enter

The syntax for the WRAPROWS function is:

=WRAPROWS(vector, wrap_count, [pad_with])

vector: The vector or reference to wrap

wrap_count: The maximum number of values for each row

pad_with: The value to pad with the last row if there are insufficient items to fill it. The default is #N/A