WRAPROWS
Wraps the provided row or column of values by rows after a specified number of elements.
Lookup & ReferenceDynamic Arrays & LAMBDALookup & Matching EssentialsModern Excel Functions
What it does
Reshapes a 1D array into a 2D array, filling row by row.
Syntax
WRAPROWS(vector, wrap_count, [pad_with])
Arguments
vector(array) — Source list.wrap_count(number) — Max items per row.
Examples
Wrap Rows
Wrap 1-4 into 2 rows.
FORMULA
=WRAPROWS({1,2,3,4}, 2)RESULT
[1, 2; 3, 4]
SAMPLE DATA
| A | B | |
|---|---|---|
| 1 | Col1 | Col2 |
| 2 | 1 | 2 |
| 3 | 3 | 4 |