FLATTEN

FLATTEN (Google Sheets only) takes one or more ranges or arrays and concatenates all their values into a single vertical list in reading order, removing all 2-D structure. Use it to consolidate data from multiple columns or ranges before applying UNIQUE, SORT, or COUNTIF.

Excel

=FLATTEN(A2:B4)

Google Sheets

=FLATTEN(A2:B4)

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

Cell row 1 column 1	Cell row 1 column 2
Cell row 2 column 1	Cell row 2 column 2
Cell row 3 column 1	Cell row 3 column 2
Cell row 4 column 1	Cell row 4 column 2

Formula

Runs server-side · free · no signup

How it works

1Identify the ranges or arrays you want to merge into a single column.
2Enter =FLATTEN(range1, [range2, ...]) in an empty cell in Google Sheets.
3The result spills as a single column; wrap with UNIQUE to remove duplicates or SORT to order results.

Need a version for your data?

Try: “Combine values from columns A and B into one vertical list.”

SORTBY SEQUENCE

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

Last reviewed: May 28, 2026

FLATTEN

Try it with your data

How it works

Related