Lining Up in One Column
Key points
- Choose FLATTEN
- Enter the range
- Copy it
In TRANSPOSE Builder you can build a formula that lines up a table in one column.
Steps
- Choose FLATTEN
- Enter the range
- Copy it
Excel uses TOCOL.
Use "Build a TRANSPOSE Formula" (free)
Tools that go well with this
- Swap Rows and Columns of a Table: Swap the rows and columns of a pasted table.
- Build a FILTER Formula: Build a FILTER formula.
- Build an ARRAYFORMULA: Build ARRAYFORMULA formulas.