# TOCOL
## Content
This function returns the array in a single column.
## Syntax
`=TOCOL(array, [ignore], [scan\_by\_column])`
## Arguments
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. |
## Data Types
The function returns an array, the type of each value in the array depends on the parameter.
## Examples
