Lesson 3.3 · Pro
Pivot: turn rows into columns
Build a report with one column per category using conditional aggregates.
In this lesson
- One column per category
- Pivot sums, not just counts
- MAX(CASE) picks the one value
Go Pro to read this lesson
Pro unlocks every lesson and practice problem in SQL, Python, pandas and NumPy, with answers and step-by-step explanations.