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!
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!