FLATTEN Function in Google Sheets

Flatten multiple ranges into a single column using the FLATTEN function.

FLATTEN Function

The FLATTEN function in Google Sheets combines multiple ranges into a single column.

Syntax

FLATTEN(range1, [range2, ...])
  • range1: The first range to flatten.
  • range2, ...: Additional ranges to include (optional).

Examples

  1. Basic Example

Flatten ranges A1:B2 and D1:E2 into a single column:

=FLATTEN(A1:B2, D1:E2)

Notes

  • All specified ranges are combined into a single column.