Excel TOROW Function

The Excel TOROW function returns an array as a single row. It’s handy for combining data across multiple columns and rows into a single row.

TOROW Function Syntax

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

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

ignore : [Optional] Use the values listed below to specify whether to ignore certain types of values. By default, no values are ignored.

• 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 in the function result are ordered by row or by column.

Note: The TOROW function is part of the new Excel Dynamic Arrays family. At the time of writing, Dynamic Arrays are only available in Microsoft 365. Excel 2021 and earlier Excel versions will not get TOROW.

Watch the Video

Download the Example Workbook

Excel TOROW Function Examples

We can use TOROW to combine the data in cells C54:D56 into a single row:

Notice the blank in cell C56 displays as a zero. We can use the ignore argument to exclude it:

And with the scan_by_column argument, we can change the order the values are stacked to be in order by column:

Related Excel Array Shaping Functions