I need to turn on repeating labels in rows of my pivot table

[ekazakoff]

I have two fields selected for row data. One field is product number and the
other field is location. There are 3 locations for every product. In the
pivot table I have the product number in the first column followed by the
location. I need to have the product number on each row next to the location
instead of the pivot table default of listing the product only once. Is
there a way to select this?

 

[Dave Peterson]

Not possible to do this and keep it a pivottable.

I copy the pivottable to a new worksheet and paste|special values. That copy is
no longer a pivottable, but I can do anything I want to the data.

Including following these techniques from Debra Dalgleish's site:
http://contextures.com/xlDataEntry02.html

 

[ekazakoff]

Thanks for the help, I never would have figured that out.

 

[Dave Peterson]

Debra has lots of good stuff at that site. You may want to bookmark it.