Pivot Data with CASE

Background

Pivoting data is common for reporting dashboards that need data in wide format.

Problem

Pivot monthly sales data from rows to columns using conditional aggregation with CASE.

Input

Long format sales data

Output

Wide format pivoted data

Sample tests

Input: monthly sales in rows

Expected: columns per month

Your solution

Learning objective

Learn data transformation and pivot patterns