Showing all rows in a pivot table

[billshat44]

I'm not sure how to ask this, but here goes. A pivot table show only
that data at each break in the sort. For example if I had a car
database with manufacturer, model, and count, the pivot table might
show this

Chevy Malibu 10
Corvette 20
Ford F150 5
Tempo 15
Dodge charger 3

 

[billshat44]

I'm not sure how to ask this, but here goes.  A pivot table show only
that data at each break in the sort.  For example if I had a car
database with manufacturer, model, and count, the pivot table might
show this

Chevy   Malibu      10
            Corvette    20
Ford     F150           5
           Tempo        15
Dodge  charger         3

Sorry I pulled the trigger too quickly. Anyway, is there a way to
show Chevy for each row that applies to Chevy, Ford for each for row
that applies to Ford etc etc. I have a formula that I can do this
outside of the pivot table but would like this within the pivot
table. Thanks

 

[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