TOROW
Returns the array in a single row.
Lookup & ReferenceDynamic Arrays & LAMBDALookup & Matching EssentialsModern Excel Functions
What it does
Transforms an array into a single row.
Syntax
TOROW(array, [ignore], [scan_by_column])
Arguments
array(array) — Source array.ignore(number) — Ignore blanks/errors.
Examples
Flatten Row
Convert 2x2 to 1x4.
FORMULA
=TOROW(A1:B2)
RESULT
[1, 2, 3, 4]
SAMPLE DATA
| A | B | |
|---|---|---|
| 1 | A | B |
| 2 | 1 | 2 |
| 3 | 3 | 4 |