Functions
TOROW
Converts an array to a single row
Try it
When to use it
When should I use TOROW?
Use TOROW to flatten a 2-D array or multi-column range into a single row — useful when building horizontal lookup tables or feeding data into HSTACK and other row-oriented functions.
Used in
Syntax
TOROW(array, [ignore], [scan_by_col])Examples
=TOROW({1,2;3,4}) // => 1
=TOROW({1;2;3}) // => 1
=TOROW({1,2,3;4,5,6;7,8,9}) // => 1