repeat row name in pivot table

[Jill]

Hi - I've been trying to figure this out for 2 hours, so if someone can help,
it would be much appreciated!

In the below pivot, I am trying to get the 'state' row name to repeat for
each row.
State Agent Policy Count
PA 032404 3
032405 17
032406 5
So for example, I want it to show
State Agent Policy Count
PA 032404 3
PA 032405 17
PA 032406 5

I am using a report created by someone else and do not have access to the
data that was used to create the pivot table. I need to copy and paste the
data from their pivot table into my own report (with their permission of
course) but as there are 20,000+ rows of data, I don't want to waste the time
copying and pasting the state name down the column. I have to copy this
report data every week.

Any suggestions? Is there maybe someway to subtotal each row and then hide
the subtotal? Thanks so much!

 

[Jill]

I forgot to mention - the Agent field is not unique - for example, the agent
032404 can exist in several states, so I need the data to look like this:
PA 032404
MO 032404
Thanks! PLEASE HELP!

 

[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