TOCOL function
Summary
Returns the array in a single column
Syntax
TOCOL(array, [ignore], [scan_by_column])
The TOCOL function syntax has the following arguments:
array The array or reference to return as a column.
ignore 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 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.
array The array or reference to return as a column.
ignore 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 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.
Example
=TOCOL(A2:D4)