# TOCOL

## Content

This function returns the array in a single column.

>type=note
> **Note**: TOCOL is a dynamic array formula, and you need to enable the dynamic array feature in the Workbook.

## Syntax

`TOCOL(array, [ignore], [scan_by_column])`

## Arguments

The function has the following arguments:

| Argument | Description |
| -------- | ----------- |
| *array* | [Required] 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:<ul><li>**0**    Keep all values (default)</li><li>**1**    Ignore blanks</li><li>**2**    Ignore errors</li><li>**3**    Ignore blanks and errors</li></ul> |
| *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. |

## Examples

![image.png](https://cdn.mescius.io/document-site-files/images/8d606653-16a0-474d-b9dc-e2b4d01c2446/image.fc4992.png)