I have a pivot table that looks like this:
State City Count
MD Balto 123
Perry 99
PA York 111
Lanc 22
Harris 11
I would like the primary sort field to repeat the text on each row like this:
State City Count
MD Balto 123
MD Perry 99
PA York 111
PA Lanc 22
PA Harris 11

Can anyone help