WRAPROWS(vector, wrap_count, [pad_width])
=WRAPROWS(A2:G2,3)
In this example, the row of values in the range A2:G2 is reformatted into an array in the range A4:C6, with each row containing a maximum of 3 columns. The last two empty positions in the array are filled with #N/A.
=WRAPROWS(A2:G2,3,"x")
The row of values in the range A2:G2 is transformed into an array located in the range A4:C6, where each row consists of 3 columns. The final two empty positions in the array are filled with the padding character "x."
The WRAPROWS function reformats the given row or column of values into a new array by wrapping the elements into rows after reaching a specified element count.