TOROW

The function returns the array in a single row.

Note: TOROW is a dynamic array formula, and you need to enable the dynamic array feature in the Workbook.

Syntax

TOROW(array, [ignore], [scan_by_column])

The function has the following arguments:

Argument	Description
array	[Required] The array or reference to return as a row.
ignore	[Optional] Whether to ignore certain types of values. By default, no values are ignored. Specify one of the following: 0 Keep all values (default) 1 Ignore blanks 2 Ignore errors 3 Ignore blanks and errors
scan_by_column	[Optional] Scan the array by column. By default, the array is scanned by row. Scanning determines whether the values are ordered by row or by column.

Argument

Description

array

[Required] The array or reference to return as a row.

ignore

[Optional] Whether to ignore certain types of values. By default, no values are ignored. Specify one of the following:

scan_by_column

[Optional] Scan the array by column. By default, the array is scanned by row. Scanning determines whether the values are ordered by row or by column.