Returns the array in a single row.

## Syntax

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

The TOROW function syntax has the following arguments:

arrayÂ Â  Â Â Â Â The array or reference to return as a row.

ignoreÂ Â  Â Â Â Â 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Â Â Â Â Â  Â 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.

## Remarks

If scan_by_column is omitted or FALSE, the array is scanned by row; If TRUE, the array is scanned by column.

## Errors

• Excel returns a #VALUE! when an array constant contains one or more numbers that are not a whole number.

• Excel returns a #NUM when array is too large.

## Examples

Copy the example data in the following table, and paste it in cell A1 of a new Excel worksheet. If you need to, you can adjust the column widths to see all the data.

Returns a single row from the array in range A2:D4 scanned by row which is the default.

Data

Ben

Peter

Mary

Sam

John

Hillary

Jenny

James

Agnes

Harry

Felicity

Joe

Formulas

=TOROW(A2:D4)

Returns a single row from the array in range A2:D4 scanned by row which is the default. Blank values return a 0.

Data

Ben

Peter

Mary

Sam

John

Hillary

Jenny

James

Agnes

Harry

Formulas

=TOROW(A2:D4)

Returns a single row from the array in range A2:D4 scanned by row which is the default. Blank values are ignored.

Data

Ben

Peter

Mary

Sam

John

Hillary

Jenny

James

Agnes

Harry

Formulas

=TOROW(A2:D4,1)

Returns a single row from the array in range A2:D4 scanned by column.

Data

Ben

Peter

Mary

Sam

John

Hillary

Jenny

James

Agnes

Harry

Formulas

=TOROW(A2:D4,1,TRUE)