Repeating rows in pivot table - how to

[Tom]

Hi,
I've run into a problem of how to repeat rows in my pivot table PT
with the intent of not having any empty cells in PT. Currently what I
have is:

Customer Name Customer ID Values
ABC1 100 Count
(goods)

Sum (revenue)

Avg (price)
ABC2 200 Count
(goods)

Sum (revenue)

Avg (price)
-------------------------------------------------------------------------------------------------------
but I whis to have:
Customer Name Customer ID Values
ABC1 100 Count
(goods)
ABC1 100 Sum
(revenue)
ABC1 100 Avg
(price)
ABC2 200 Count
(goods)
ABC2 200 Sum
(revenue)
ABC2 200 Avg
(price)

 

[Dave Peterson]

Not 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

 

[Tom]

So it can't be done thru pivottable itself. That's sad.
Thanks for info and that trick for filling blank cells.

Tom