Google Sheets FLATTEN – Excel Alternative | ComTools
Google Sheets FLATTEN explained: Excel support (Not supported), Excel alternatives (TOCOL), convert online free.
What is Google Sheets FLATTEN?
Flattens nested ranges into one column (Sheets).
Excel compatibility
On Excel, FLATTEN is marked as Not supported. Excel 365: TOCOL. Older Excel needs helper formulas.
Try the converter
Open the Excel Formula Converter, set target to Excel or Sheets, and paste your formula.
FAQ
QIs FLATTEN available in Excel?
Status: Not supported. Alternative: TOCOL.