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

How To Use in Sheets


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.

2Better Sheets Tutorials

Check out how to use flatten()


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