WRAPCOLS
Wraps the provided row or column of values by columns 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 column by column.
Syntax
WRAPCOLS(vector, wrap_count, [pad_with])
Arguments
vector(array) — Source list.wrap_count(number) — Max items per column.
Examples
Wrap Columns
Wrap 1-4 into 2 columns.
FORMULA
=WRAPCOLS({1,2,3,4}, 2)RESULT
[1, 3; 2, 4]
SAMPLE DATA
| A | B | |
|---|---|---|
| 1 | Col1 | Col2 |
| 2 | 1 | 3 |
| 3 | 2 | 4 |