Goal: Reshape a 2D Matrix into a 1D List.
TOCOL: Stacks data vertically.
TOROW: Lays data out horizontally.
Ready...
💻 Formula Structure
=TOCOL(array, [ignore], [scan_by_col])
- 1. Array: The range to flatten.
- 2. Ignore: 0=Keep All, 1=No Blanks, 2=No Errors.
- 3. Scan By Col: FALSE (Row-by-Row, Default), TRUE (Col-by-Col).
=TOROW(array, [ignore], [scan_by_col])
- Action: Transforms array into a single horizontal row.
- Args: Same options as TOCOL.
-- Flatten array
=TOCOL( A1:C3 )
⚠️ Power Tip
🧹 Ignoring Blanks
Use the 2nd argument to clean data instantly.
=TOCOL(A1:C10, 1) removes empty cells and collapses the list perfectly.