showing repeating values in the rows of a pivot table

[Guest]

The default setting in pivot tables results in showing the repeating value of
a row header in the first row only. Is it possible to allow the repeating
value to populate all the cells to which it applies?

 

[Dave Peterson]

Not while it's still a pivottable.

I'll usually convert to values (or make a copy of that pivottable and convert
that copy to values).

Then I'll use techniques like those at Debra Dalgleish's site to fill those
empty cells:

http://www.contextures.com/xlDataEntry02.html