Remove Supression on Repeated Values in a Pivot Table

[hellomynameiskristin]

Is there a way to remove Supression on repeated Values in a Pivot?

Meaning, the pivot looks like this

Roses..........Red........24
.................Green......30
.................Pink.........26

But I want it to look like this:

Roses..........Red........24
Roses..........Green......30
Roses..........Pink.........26

Any help? I am using Excel 2002. TIA!

 

[rallcorn]

Not available within pivot table itself until Excel 2010.

If you're interested in copying & doing it on a separate sheet, 1st couple of responses in the following post will walk you through it.

http://www.mrexcel.com/forum/showthread.php?t=529659

 

[hellomynameiskristin]

Dang. Thanks anyways!