FUNCTION CATALOGUE / LOOKUP & REFERENCE
TOCOL Excel function
Converts an array into one column.
Correct sentence to use
Flatten [array] into a single column.
Modify this query in PlainFormula →Example formula
=TOCOL(A1:C10)
Returns an array as one column.
Syntax
TOCOL(array, [ignore], [scan_by_column])
Argument signature: array, [ignore], [scan_by_column]
Availability note
Available in supported Microsoft 365 / newer Excel versions; verify the exact release and platform.