TOCOL
Returns the array as one column
Syntax
TOCOL(array, [ignore], [scan_by_column])
Parameters
- array: Required. The array or reference to return as a column
- ignore: Optional. Whether to ignore certain values (0=keep all, 1=ignore blanks, 2=ignore errors, 3=ignore blanks and errors)
- scan_by_column: Optional. FALSE to scan by row (default), TRUE to scan by column
Example
=TOCOL(A1:C3)