FLATTEN()

Description

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

How To Use in Sheets

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

External Links

FLATTEN Function - Google Sheets - Transform Data to One Column

Learn how to use FLATTEN function in Google Sheets. FLATTEN function helps you flatten arrays to a single dimension, in case of spreadsheets we can take a range with multiple columns of data and move it to a single column.

Google Docs Help

2Better Sheets Tutorials

Wrangle Scattered Data with Flatten()

Beginner

Check out how to use flatten()

FREE

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.