TOROW
Returns the array as one row
Syntax
TOROW(array, [ignore], [scan_by_column])
Parameters
- array: Required. The array or reference to return as a row
- ignore: Optional. Whether to ignore certain values (0=keep all, 1=ignore blanks, 2=ignore errors, 3=ignore blanks and errors)
- scan_by_column: Optional. FALSE to scan by row (default), TRUE to scan by column
Example
=TOROW(A1:C3)