TOCOL

The TOCOL function returns an array in a single column.

TOCOL(array, ignore, scan-by)

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

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

  • TOCOL returns an error if 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

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

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

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

See alsoTOROW
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.