Thank you everyone for your help. Don, I found your solution to work best.
THANKS SO MUCH! You've saved me hours of work!

"Don" wrote:

Ok, how about this, insert a few columns before and say PA appears in D3,
then in A3 put =D3 but on A4 put =if(D4="",A3,D4) then drag that down and to
the right. It should populate in the first few columns what you need?

"Jill" wrote:

Hi - I tried to figure this out for 3 hours now and am desparate, so if
someone can please 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!