How to Use FLATTEN() in Google Sheets

Description

Flattens all the values from one or more ranges into a single column.

How To Actually Use FLATTEN() in Sheets

FLATTEN(range1,[range2,...])

Try FLATTEN yourself

Use the FLATTEN function to combine all values from the range A1:C3 into a single column. The result should be displayed in cell E1.

Your formula

Hints (2)

Locale Separator ,

Official Docs

3 Better Sheets Tutorials

Wrangle Scattered Data with Flatten()

Check out how to use flatten(). Discover the funky formula that makes data wrangling a breeze! Learn how to use Flatten in Google Sheets to organize scattered data and get insights that were previously hidden. Read on to see how this simple trick can save you hours of manual labor.

Beginner

FLATTEN()

This Seems Like Automation

4 formulas that make your sheets feel automated. Start with user-started actions, and get automated data flowing in other parts of your sheet.

FILTER() FLATTEN() IF() IFERROR() TRANSPOSE() +1 more

Alejandro Asks: How do I Sum up Study hours from a Calendar Format?

A member, Alejandro, asks about taking their custom calendar inputs and figuring out study totals for a week. They created a beautiful input and just need to the calculations. I show how to use the data to do the calculations. If you've never used the FLATTEN() formula, this is a good example! And we use double UNIQUE().

FILTER() FLATTEN() SORT() SUM() UNIQUE()

Learn more about the FLATTEN() formula:

Generate a FLATTEN() formula for your needs

Describe your task in plain English and get a paste-ready formula that uses FLATTEN(). 2 free AI generations, no signup. Members get unlimited use.

Generate a FLATTEN() formula