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