TOROW Function

Flattens a block of cells into one row.

Category

Lookup & Reference

Available in

Microsoft 365, Excel 2024

Returns

A single spilled row

Want to practice TOROW in a real spreadsheet? Open a blank sheet in our Practice Sandbox and try it with live data, with the AI Excel tutor beside you. No Excel needed — just a free account.Try it free in the Sandbox

Overview

TOROW is TOCOL sideways: it lays every value from a grid out in one row.

The same options let you skip blanks or errors and choose the reading direction.

Syntax

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

Arguments

ArgumentRequired?What it does
arrayYesThe range or array to flatten.
ignoreOptional0 = keep all (default), 1 = skip blanks, 2 = skip errors, 3 = skip both.
scan_by_columnOptionalFALSE = read row by row (default), TRUE = read column by column.

Examples

Example 1 — Reading down columns

Flatten a 2×2 block, reading down each column first.

A4fx=TOROW(A1:B2, , TRUE)
ABCDEF
1AnaBen
2CaraDev
3
4AnaCaraBenDev
=TOROW(A1:B2, , TRUE) Explain

Example 2 — A header row from a list

Turn a vertical list of months into a horizontal header, skipping blanks.

=TOROW(A2:A20, 1) Explain

Common mistakes

  • Running out of columns. Very large grids may exceed the 16,384-column limit — use TOCOL instead.

Notes

Kyle Stott

Author

Kyle Stott

Certified Microsoft Excel Expert

Kyle has worked professionally with Microsoft Excel for over a decade and has consulted on and taught Excel best practices to over 400 companies across 30+ countries.