Excel functions / Dynamic arrays

TOROW function

Turns an array into a single row.

Syntax

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

Arguments

When to use it

TOROW turns a range into a single row, reading row by row. With 1 as the second argument it skips empty cells.

Examples

  1. A column as a row

    ABCDE
    1ItemPenStaplerFolder
    2Pen
    3Stapler
    4Folder
    5Tape
    6Glue
    7Ruler

    In C1: =TOROW(A2:A4) → Pen, Stapler, Folder

    Try this example

Common mistakes

TOROW in other languages

Excel shows function names in its own language. In these languages it also puts a semicolon between arguments where English has a comma.

Translate a whole formula

Try TOROW in the playground

Related functions