TOCOL

This function returns the array in a single column.

Syntax

=TOCOL(array, [ignore], [scan\_by\_column])

The function has the following arguments:

Argument	Description
array	The array or reference to return as a column.
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

The array or reference to return as a column.

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.

The function returns an array, the type of each value in the array depends on the parameter.