Excel like a finance pro.
Pivot tables · Layout
Repeat item labels
Fills the row labels on every row instead of only the first of each group, so the output can be used as flat data.
When to use it
Repeat All Item Labels fills the outer row labels on every row instead of only the first of each group, so the output can be used as flat data.
The shape of it
- How
Design, Report Layout, Repeat All Item Labels.
Worked examples
Repeat labels
Design, Report Layout, Repeat All Item Labels → Region appears on every product row
Flat rows.
Flatten recipe
Tabular form plus repeated labels plus subtotals off → A clean table
The flattening recipe.
Reset
Do Not Repeat Item Labels → Back to grouped labels
Reset.
Worth knowing
- Needed for VLOOKUP or a second pivot on the output.
- Only affects outer row fields.
- Copy and Paste Values to freeze the flat table.
Where it goes wrong
- Merged-cell look is lost, which some readers prefer.
- Compact form ignores the setting.
Related
Learn the moves here — or let Wauvel run them on your numbers.
Meet your AI CFO →One CFO-grade Excel tip a week
A short, practical email for finance operators — functions, shortcuts, and the moves that save an afternoon. Free, unsubscribe anytime.