Spilling Results
Key points
- Build the formula
- Paste it in an empty cell
- Check it
The formulas from TRANSPOSE Builder spill their results down and to the right.
Steps
- Build the formula
- Paste it in an empty cell
- Check it
Leave the cells it spills into empty.
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.