# WRAPROWS

Formulas / WRAPROWS
To wrap a row or column by a certain number of rows which creates a new array.
`WRAPROWS(vector, wrap_count, [pad_width])`
• vector - The input vector or reference that is to be wrapped.
• wrap_count-The maximum number of elements allowed in each row of the resulting array.
• pad_width - [optional]The value used for padding, if needed. By default, this value is set to #N/A.

## Examples

• `=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."

## Summary

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.

• If the vector is not a one-dimensional array, WRAPROWS function will display the #VALUE error.
• If the wrap_count is less than 1, the WRAPROWS function will display the #NUM! error.
• When there are no results for a cell in the return array, the WRAPROWS function will display the #N/A error.

How does the function work when the elements of a vector are placed into a 2-dimensional array by row?
When the elements of a vector are placed into a 2-dimensional array by row, each row of the array contains a specified number of elements, referred to as the wrap_count.
what happens when there are insufficient elements to fill a row?
If a row does not have enough elements to reach the wrap_count, it is padded with a specified value, known as pad_width, to fill the remaining positions.
what happens when the wrap_count is greater or equal to the number of elements in the vector?
If the wrap_count is greater than or equal to the total number of elements in the vector, the function simply returns the original vector as a single row without any padding.

## Make Better Decisions With Data

Analyze data, automate reports and create live dashboards
for all your business applications, without code. Get unlimited access free for 14 days.

Drop CSV