Reference · Visual workspace
Pivot long data to wide in Visual workspace
Spread a key column into declared columns, one row per index, leaving absent combinations missing.
When to use it
Monthly or category readings that a report needs side by side.
How
Add step → Reshape → Pivot. Tick the row columns, choose the key and value columns, and list the new columns one per line.
Pivot month into Jan, Feb, Mar by entity
- A key value not in the list stops the step, so nothing is dropped silently.
Pitfalls
- Filling gaps with zero.
- Letting each batch decide the columns.
Lesson: Pivot without inventing zeros
Practise it: Pivot monthly values, keeping zeros and gaps apart