In this article:

FLATTEN Function in Google Sheets: Complete 2024 Guide

May 8, 2024

What Is the FLATTEN Function in Google Sheets?

The FLATTEN function in Google Sheets is used to transform a range of values into a single column, effectively "flattening" a two-dimensional range into a one-dimensional list. 

This can be particularly useful when you're working with data spread across multiple rows and columns but need to process or analyze it as a continuous series of values.

The basic syntax of the FLATTEN function is simply:


Where the range is the range of cells you want to flatten. 

How to Use the FLATTEN Function in Google Sheets

Suppose you have a dataset in cells A1:C3 and you want to flatten this range into a single column.

1.  Choose Where to Place Your Output

Decide on where you want the flattened data to appear in your sheet. 

It's essential to select a starting cell that is sufficiently far from your original data range to prevent overwriting any existing data. For example, you might choose cell E1 as the starting point for the flattened output.

google sheets flatten

2. Enter the FLATTEN Function

Click on the cell where you've decided to place the output (E1). Type in the FLATTEN function followed by the range you want to flatten. Your input should look like this:


flatten google sheets

Press Enter. 

3. Check Your Flattened Data

The range A1:C3 will now appear flattened in a single column, starting from E1 downwards.

flatten function google sheets

We hope that this article has helped you and given you a better understanding of how to use the FLATTEN function in Google Sheets. If you enjoyed this article, you might also like our articles about the difference between Google Sheets comments vs notes and on how to insert the delta symbol in Google Sheets.

Get Google Sheets productivity and automation tips delivered straight to your inbox
Thank you! Your submission has been received!
Oops! Something went wrong while submitting the form.
We'll email you 1-3 times a week — and never share your information.
Get your copy of our free Google Sheets automation guide!
  • 27 pages of Google Sheets tips and tricks to save time
  • Covers pivot tables and other advanced topics
  • 100% free

Work less, automate more!

Use Lido to connect your spreadsheets to email, Slack, calendars, and more to automate data transfers and eliminate manual copying and pasting. View all use cases ->