FUNCTION CATALOGUE / LOOKUP & REFERENCE
TOROW Excel function
Converts an array into one row.
Correct sentence to use
Flatten [array] into a single row.
Modify this query in PlainFormula →Example formula
=TOROW(A1:C10)
Returns an array as one row.
Syntax
TOROW(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.