Layout and values Updated November 2026

Repeat row labels

Click in the pivot, open Design, Report Layout and choose Repeat All Item Labels. The outer field's value is then written on every row of its group instead of only the first one, which is what you need before copying the pivot as values or using it in VLOOKUP.

Syntax

Design > Report Layout > Repeat All Item Labels

Part	What it is
`Repeat All Item Labels`	Applies to every row field
`Field Settings > Layout & Print > Repeat item labels`	Per-field version, for one field only
`Google Sheets`	Pivot table editor, row field, tick Repeat row labels

Examples

Rows: Region, Rep (Tabular Form)
Design > Report Layout > Repeat All Item Labels

Result: East appears next to every East rep, not only the first one.

Right-click Region label > Field Settings > Layout & Print > Repeat item labels

Result: Only Region repeats; other row fields keep the standard single label.

Common mistakes

The option is grayed out: it only works in Outline or Tabular form, so change the Report Layout first.
Labels repeat but subtotal rows break the list: turn off subtotals and grand totals for a clean copyable block.
Copy and paste still gives blanks: you copied before turning on the option, or you are in Compact form.

Practice Repeat row labels

These drills check your answer on live data, free, no account needed.

Region, then repShow total Revenue by Region, and within each region by Rep.
Channel, customer type and feesShow total Sales and total Fees by Channel, and within each channel by Customer.

Questions

Why are the cells under a row label blank in a pivot table?

By default the outer label is shown once per group. Repeat All Item Labels writes it on every row.

How do I repeat row labels in Google Sheets pivot tables?

Open the pivot table editor, find the row field and tick Repeat row labels.

Tabular layoutSwitch a pivot table to Tabular Form so every row field gets its own column, compare Compact, Outline and Tabular, and make Tabular the default layout.
Two row fieldsPut two or more fields in Rows to nest categories, choose which field is outer and inner, collapse groups and switch to tabular layout for separate columns.
Copy a pivot table as valuesTurn a pivot table into plain cells with Copy, Paste Special, Values and Number Formats, keep the look with Keep Source Formatting, set tabular layout first.