I have discovered that many Excel functions do not work in a pivot table and
I have to copy and paste special to another worksheet to perform certain
sorts.
If I have primary and secondary rows like

State1 City1
City2
State2 City1
City2
Is there any way to force the state to show up on each line with the cites
so records can be kept together in a sort??
Thanks
--
rsmith333