How to display repeating data in Pivot Tab

[Guest]

Hello,

I have a Pivot Table which displays 3 fields. By defaults, Excel groups the
data and removes the repeating data. For example, I have the following:

CustId Account# Balance
1 A1 200
1 A2 300
2 A3 400

Excel displays this as,

CustId Account# Balance
1 A1 200
A2 300
2 A3 400

Note that it doesn't display CustId in the 2nd row. But I want it to display
it. How can I do this?

Thanks
Vasan

 

[Max]

Try Debra Dalgleish's page for
some nice ideas on filling in the blank cells:
http://www.contextures.com/xlDataEntry02.html
Fill Blank Cells
Fill Blank Cells Programmatically

 

[Dave Peterson]

But this won't work if it's still a pivottable.

The OP can either copy|paste special|values first, then do this.

Or copy to a new worksheet (as values). Then do it against that sheet.

 

[Max]

But this won't work if it's still a pivottable.

Thanks. Yes, I missed that point in the OP.