FLATTEN

FLATTEN function in Google Sheets: Flattens ranges into a single column.

November 5, 2026

Array function · Google Sheets

FLATTEN function

Flattens ranges into a single column.

Platform	Status
Excel	Not listed
Google Sheets	Listed

On Excel: use TOCOL. TOCOL also has options to skip blanks and errors.

Reference entry. Syntax, tested examples and a practice file arrive with the full guide. Open the official function list.