FormulaCraft

TOCOL

TOCOL flattens a range or array into a single column, reading values left-to-right and top-to-bottom by default. You can optionally skip blanks or errors, and control the scan order. It is an Excel 365 and Google Sheets dynamic function that complements TOROW for reshaping data.

Excel
=TOCOL(A2:B3)
Google Sheets
=TOCOL(A2:B3)

Try it with your data

Edit the grid or formula, then run it through a real spreadsheet engine — no signup.

Sample data — click any cell to edit

Runs server-side · free · no signup

How it works

  1. 1A2:B3 is the source range — it contains 2 rows and 2 columns, so 4 values total.
  2. 2TOCOL reads values row by row (left-to-right, top-to-bottom) by default.
  3. 3The result is a single vertical column of 4 cells: A2, B2, A3, B3.

Need a version for your data?

Try: “Stack all values from a 2x2 table into one column”

Related

VLOOKUPXLOOKUPINDEX / MATCH

Written and reviewed by FormulaCraft Team. Each formula on this page is run through our verification engine before publishing.

Last reviewed: