Transforms the given array into a single column.
Syntax
TOCOL(array; [ignore]; [direction])
array: The range of cells containing the values to transform. Eg., A2:C3
ignore: Specifies the values to ignore in the given array. Defaults to 0 if omitted.
0 - Keep all values.
1 - Ignore blank cells
2 - Ignore errors
3 - Ignore blank cells and errors
direction: Specifies how the given array must be read. If TRUE, the array will be scanned by column. If FALSE or omitted, the array will be scanned by row.
Examples
Formula |
=TOCOL(A2:C3;1) |
=TOCOL(A6:C8;1;TRUE) |
Get a hands-on experience of the function in the embedded range below.
Possible Errors
Errors | Meaning |
#NAME! | The function name is incorrect or invalid. The given defined name (if any) is invalid. There is a typo in the defined name used in the function. Double quotes are missing for text values in the function. Colon missing in a cell range reference.
|
#VALUE! | - The given argument's data type is incorrect or invalid.
|
#REF! | |
#NUM! | |
Similar Functions