SheetFX
≡
<< Go back to all functions

FLATTEN

The FLATTEN function in Google Sheets is a powerful tool to flatten all the values from one or more ranges into a single column. Whether you're working with multiple ranges or organizing data in a more concise format, the FLATTEN function simplifies the task. Dive into our comprehensive guide to master its application.

Function Syntax and Parameters

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

Parameters:

  • range1: The first range of cells to flatten.
  • range2, ...: [Optional] Additional ranges of cells to flatten.

Step-by-Step Tutorial

  1. Using FLATTEN with a single range:

    • Example: If A1:A3 has the values 1, 2, 3, then =FLATTEN(A1:A3) will return:
    1
2
3

  2. Using FLATTEN with multiple ranges:

    • Example: If A1:A3 has the values 1, 2, 3 and B1:B3 has the values 4, 5, 6, then =FLATTEN(A1:A3, B1:B3) will return:
    1
2
3
4
5
6

Use Cases and Scenarios

  1. Data Organization: Create a more compact representation of data from multiple ranges.
  2. Data Analysis: Consolidate data from different sources into a single column for analysis purposes.
  3. Formatting: Flatten data to simplify formatting and styling tasks.

Related Functions

  • QUERY: Extract and filter data based on specific criteria.
  • TRANSPOSE: Transpose rows and columns in a range or array.

Related Articles