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.


Frequently Asked Questions

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.