Excel like a finance pro.
← The libraryPractice · 2 questions →
Dynamic array function
TOROW
Flattens an array into a single row.
Rarely usedDifficulty 1400 · AdvancedUsage rank #113 of 520
When to use it
Flattens an array into a single row.
The shape of it
- Syntax
=TOROW(array, [ignore], [scan_by_column])
Worked examples
Column to row
=TOROW(A1:A5) → five values across
A column becomes a row.
Flatten a block
=TOROW(A1:C2) → six values across
Row by row.
Skip blanks
=TOROW(A1:C3,1) → non-blank values across
Skip blanks.
Worth knowing
- Same options as TOCOL.
- Handy for building a header row from a column of names.
- TEXTJOIN(",",TRUE,TOROW(range)) makes a comma list.
Where it goes wrong
- Requires Microsoft 365.
- Blanks become 0 unless ignored.
Related
Learn the moves here — or let Wauvel run them on your numbers.
Meet your AI CFO →One CFO-grade Excel tip a week
A short, practical email for finance operators — functions, shortcuts, and the moves that save an afternoon. Free, unsubscribe anytime.