Pro exercise

Totals per month from a wide sheet

A sheet has one row per store and one column per month. To total each month across stores, reshape to one row per store and month first. Blank cells are months a store didn't report: they are skipped, counted as missing coverage, never as 0.

unpivot
aggregation
coverage