# TOROW

## Content

The function returns the array in a single row.

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

## Syntax

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

## Arguments

The function has the following arguments:

| Argument | Description |
| -------- | ----------- |
| *array* | [Required] The array or reference to return as a row. |
| *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

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