Must say hard for me to see exactly what is messing up for you so the attachment tmw will help tremendously.

If you are just pivoting the City and State with only one row per it seems to work fine for me on a test by placing city and state as row labels in tabular form.

Again, maybe I don't fully see what your picture is so it will have to be when you get a sample file ready.