One row per product, pivoted from twelve monthly rows

A manager wants one row per product with a column for each month, spread out the way it already looks in an Excel pivot table on their screen.

IntermediateRead 5 minDoing: under an hour7 steps

▶ Start

What you'll have at the end

One query producing one row per product with a column per month, matching the pivot table it replaces

Before you start

You need

A single table with one row per product per month, combining every month into one place already, with a product name, a month, and a revenue figure on each row.

Not covered

Generating the column list automatically when a new month rolls in or a new product line appears; every month name here is still typed out by hand.

Leans on

7 steps

Where to go next

Combine three monthly sales exports into one table with UNION

go there first if the twelve monthly figures still live in separate exports rather than one combined table

Track month over month growth with LAG

go there instead when the manager wants one growth number, not a full twelve-column grid

Checked 26 Aug 2026

Part of the SQL for Data Analysis cookbook