Skip to Content

How to Use the FLATTEN Function in Google Sheets

There may be times when working in Google Sheets that you want to put an entire range of data into a single column.

Luckily there is a built-in function called FLATTEN that makes this incredibly easy to do.

In this tutorial, I will show you how to use the FLATTEN function in Google Sheets.

Table of Contents

FLATTEN Syntax

The FLATTEN function takes the values in one or more ranges and places them into a single column.

The syntax of the FLATTEN function is:

=FLATTEN(range1, [range2, …])

  • range1 – this first range to place into a single column
  • range2 – This is an optional argument. You can continue to place additional ranges in the formula here

Using FLATTEN

Now that we have covered the basic syntax of the FLATTEN function. Let’s take a look at how to actually use it in our spreadsheet.

In this example, I will be taking a range of data and returning it in a single column using FLATTEN.

Here is how this is done:

Place the range of data that you want to return into a single column in the function. You can also place more then one range.

FLATTEN-1

After the function calculates, you should now see your entire range in a single column like in the below picture.

FLATTEN-2

Closing Thoughts

FLATTEN is a very useful function that many users don’t know about.

It becomes even more useful when you begin to combine it with other functions in creative ways. That is beyond the scope of this post, but in the future, I may possibly show some more advanced ways to use it!

More Google Sheets Tutorials:
How to Use the ARRAY_CONSTRAIN Function