Level 3QUERYPractice, 4 min

QUERY: one quarter, pivoted by month

The task

In F1, show Q1 2026 leads with one row per channel and one column per month. Keep only dates from January 1 up to (not including) April 1, group by channel and pivot by month: =QUERY(A1:D14, "select C, sum(D) where A >= date '2026-01-01' and A < date '2026-04-01' group by C pivot B")

The data

The starting sheet. Cells outlined in green are where your formulas go.

ABCDEF
1DateMonthChannelLeads
2Dec 15, 2025Dec 2025Email40
3Jan 8, 2026Jan 2026Paid Search120
4Jan 14, 2026Jan 2026Email45
5Jan 22, 2026Jan 2026Paid Social80
6Feb 3, 2026Feb 2026Paid Search132
7Feb 11, 2026Feb 2026Email51
8Feb 19, 2026Feb 2026Paid Social74
9Feb 25, 2026Feb 2026Paid Search18
10Mar 4, 2026Mar 2026Paid Search141
11Mar 12, 2026Mar 2026Email38
12Mar 18, 2026Mar 2026Paid Social96
13Mar 30, 2026Mar 2026Email12
14Apr 2, 2026Apr 2026Paid Search150

See all lessons