TOROW
Description
Returns the specified array as a single row.
Syntax
TOROW(
array
, [ignore
],
[scan_by_row
]) - array: The array or reference to return as a row.
- ignore: Specifies whether to ignore certain types of values. By default, the function doesn't ignore any values. Possible values are: 0 = Keep all values. 1 = Ignore blanks. 2 = Ignore errors. 3 = Ignore blanks and errors.
- scan_by_column: Scan the array by column. By default, the function scans the array by row. Scanning determines whether the values are ordered by row or by column.