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
| Argument | Required? | What it does |
|---|---|---|
| array | Yes | The range or array to flatten. |
| ignore | Optional | 0 = keep all (default), 1 = skip blanks, 2 = skip errors, 3 = skip both. |
| scan_by_column | Optional | FALSE = 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)
| A | B | C | D | E | F | |
|---|---|---|---|---|---|---|
| 1 | Ana | Ben | ||||
| 2 | Cara | Dev | ||||
| 3 | ||||||
| 4 | Ana | Cara | Ben | Dev |
=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

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.