Pivot table

[ApolloID]

Hi, i have a pivot table that looks like this:

London...........Jim
....................John
....................Mary
Washington.....Jim
.....................Bob
.....................Mary
.....................Fran

I need the pivot table to be set up to look like this:
London...........Jim
London..........John
London..........Mary
Washington.....Jim
Washington.....Bob
Washington.....Mary
Washington.....Fran

Can this be done?
Thanks!

 

[harshab6]

hi,
Please take a look atb this video
http://www.datapigtechnologies.com/flashfiles/pivot8.html

regards
harsha

 

[ApolloID]

Is not was i was looking for, but this is great!
Is so much less time consuming.
Thanks allot!