Ravindra BagaleCourses & study guides Track your progress

Excel TOROW Function

By · Last updated:

Chala mitrano — today TOROW. Turn a grid into one wide row — labels and merge fields.

Fictional sample data for learning. One-line exports for Madurai labels and Montreal mail-merges.

Purpose

Flatten an array into a single row.

Return value

A spilled row vector.

Syntax

TOROW(array, [ignore], [scan_by_col])

Arguments

ArgumentRequired?Description
arrayRequiredArray to flatten.
ignoreOptional0/1/2/3 as in TOCOL.
scan_by_colOptionalTRUE reads by column.

Version

Microsoft 365. Not in perpetual Excel 2019 without dynamic arrays. Sheets has partial cousins.

How to use — Why → What → How

Why: Some exports want a single horizontal line. TOROW flattens that way. One-line exports for Madurai labels and Montreal mail-merges. In Indian back offices and foreign sister teams, TOROW shows up on live dashboards and spill ranges every week.

What: TOROW walks row-wise by default. Same ignore codes as TOCOL. Read every argument in the table once before you type; each one changes the answer on purpose.

How — numbered steps:

  1. Type =TOROW(A2:C5).
  2. ignore 1 skips blanks.
  3. Use TOCOL when you need a tall list.

Ravindra Bagale's Tip

Friends, after TOROW, find one column or range in a real workbook this week where this lesson saves time.

Ravindra Bagale's Tip

Friends, sleep on TOROW; rebuild example 1 tomorrow without looking.

Ravindra Bagale's Tip

Friends, say the business question in plain words before =TOROW.

Ravindra Bagale's Tip

Friends, check a known case with a calculator before you trust a long TOROW chain.

Ravindra Bagale's Tip

Friends, after you finish TOROW, open yesterday’s real workbook and find one place this function would have saved ten minutes.

Ravindra Bagale's Tip

Friends, treat TOROW like a seatbelt on spill ranges — clear #SPILL! blocks first.

Download practice file: practice-torow.xlsx (includes sheet About this data, practice sheets, and Answers).

Worked examples

1) Flatten row

Madurai.

AB
12
34
Formula: =TOROW(A2:B3)

Result: {1,2,3,4}

What it means: One row.

2) Skip blanks

ignore.

AB
1None
34
Formula: =TOROW(A2:B3,1)

Result: {1,3,4}

What it means: Blanks out.

3) By column

scan.

AB
12
34
Formula: =TOROW(A2:B3,,TRUE)

Result: {1,3,2,4}

What it means: Col order.

4) Montreal $

Fees.

AB
1020
3040
Formula: =TOROW(A2:B3)

Result: {10,20,30,40}

What it means: Wide.

5) Single col in

Already col.

X
1
2
3
Formula: =TOROW(A2:A4)

Result: {1,2,3}

What it means: Became row.

6) #SPILL!

Needs width.

X
1
Formula: =TOROW(A2)

Result: #SPILL! when right cells full

What it means: Clear neighbors.

Common errors and fixes

#SPILL! — Needs free cells to the right. Fix: Clear.
ignore — Same codes as TOCOL. Fix: 1 for blanks.
Direction — Horizontal spill. Fix: vs TOCOL vertical.

Notes and tips

  • Revisit the TOROW errors table after the quiz.
  • Build example 1 from memory on a blank sheet.
  • Check number vs text if a result looks wrong.
  • Teach one tip in Marathi or Hindi this week.
  • Keep currency symbols consistent inside one report column (practice mixes ₹ $ £ €).
  • Drill: TOROW a 2×2 into four horizontal cells.
  • TOROW vs HSTACK: flatten nested vs glue ready blocks.
  • Fictional sample data only — names and amounts are for learning.
  • Print the TOROW revision card for one week of real worksheets.
  • Ask juniors to predict before they press Enter.
  • Track your top mistake with this function monthly.
  • One-line exports for Madurai labels and Montreal mail-merges.
  • Interview tip: explain the business question before the formula.
  • Classroom drill: invent three brand-new formulas from your city without the page open.
  • If a result looks wrong, check blanks vs zeros before rewriting.
  • When Excel versions differ, note the LibreOffice / Sheets fallback in a cell comment.
  • Prefer clear ranges over whole-column refs on huge sheets if speed matters.
  • Document units (₹, kg, days) in the header so totals stay honest.
  • Print the revision card for TOROW for one week of real worksheets.
  • When helping a junior, ask them to predict before Enter.
  • Share one tip with a classmate in Marathi or Hindi.
  • Keep currency symbols consistent inside a single report column.
  • Interview tip: explain the business question before the formula.
  • If a result looks wrong, check spill range blocks (#SPILL!) before rewriting.
  • When Excel versions differ, write a LibreOffice / Sheets fallback under a comment.

In real work

Drill: TOROW a 2×2 into four horizontal cells. One-line exports for Madurai labels and Montreal mail-merges. Classroom drill: write three brand-new TOROW formulas on a blank sheet using names from your own city — if you can invent them without the page open, you own the skill. Then break one formula on purpose and watch the error; recovering from that break is half of interview readiness. Always verify with a known case before trusting a long chain. Keep a personal notebook of the one mistake you make most often with this function; review it monthly.

How it compares

TOROW vs HSTACK: flatten nested vs glue ready blocks.

Interview corner

vs TOCOL?
Row vs column.
ignore 1?
Skip blanks.
Spill?
Horizontal.

TOCOL, HSTACK, WRAPCOLS

Practice tasks (10)

  1. Task 1. Flatten to row.
    TOROW.
  2. Task 2. Skip blanks.
    1.
  3. Task 3. By column.
    scan.
  4. Task 4. Col→row.
    Vector.
  5. Task 5. Montreal grid.
    $.
  6. Task 6. Interview.
    Talk.
  7. Task 7. Teach.
    Teach.
  8. Task 8. Clear spill.
    Space.
  9. Task 9. Fill.
    Fill.
  10. Task 10. Document.
    Note.

Quick quiz

Q1. TOROW result shape?
Q2. ignore 1?
Q3. Cousin tall?
Q4. 2×2 length?
Q5. Blocked right?

Answers: Q1=One row, Q2=Skip blanks, Q3=TOCOL, Q4=4, Q5=#SPILL! (check after you try).

Revision card

Standalone card (no tip or photo strip). QR opens this lesson. Download the PNG and revise offline.

Revision card: TOROW
TOROW revision card