Repeat all labels in an Excel pivot table

Following on from a previous blog post on how to flatten a pivot table in Excel, this trick repeats all the labels in a flattened pivot table.

In the previous blog post, we were left with a flattened pivot table where by default the Year labels only appear once per set of Areas.

In order to make the format more usable, click anywhere on the pivot table to activate the PivotTable Tools menu. Click Design, then Report Layout & then Repeat All Item Labels.

This will cause the labels to appear on each row & make it easier to explore data.