Products, services, and OS functions
may not be available in this country.

TOROW

The TOROW function returns an array in a single row.

TOROW(array, ignore, scan-by)

array: The array or reference to return as a row.

ignore: An optional modal value determining if certain types of values should be ignored. By default, no values are ignored.

keep all values (0 or omitted): Keep all values (default).

ignore blanks (1): Ignore blanks.

ignore errors (2): Ignore errors.

ignore blanks and errors (3): Ignore blanks and errors.

scan-by: Scan the array by column. By default, the array is scanned by row, but scanning determines if the values are ordered by row or column.

scan by row (FALSE or omitted): The array is scanned by row. This is the default selection.

scan by column (TRUE): The array is scanned by column.

Notes

  • TOROW returns an error when the array is too large.

  • You can use the spilled range operator “#” to reference an array created by a formula.

Examples

Given the following table:

A

B

C

D

1

Aga

Danny

Fleur

Andre

2

Elisha

Po-Chun

Nisha

3

Orkun

Jasmine

Liz

=TOROW(A1:D3) returns a single row from the array in the range A1:D3 scanned by row, which is default. Blank values return a 0.

=TOROW(A1:D3, 1) returns a single row from the array in the range A1:D3 scanned by row, which is default. Blank values are ignored.

=TOROW(A1:D3, 1, TRUE) returns a single row from the array in the range A1:D3 by column. Blank values are ignored.

See alsoTOCOL
Morty Proxy This is a proxified and sanitized view of the page, visit original site.
Helpful?
Character limit: 250
Maximum character limit is 250.
Thanks for your feedback.
Morty Proxy This is a proxified and sanitized view of the page, visit original site.