Hi everyone:
I am working on a pivot table that includes 71 different cities and the factors assigned to each of them. When I organize the data by factors, some of them (not all) appear twice, even though they are idential, have same formatting, etc.

For instance, there are seven cities with a factor of 1, and instead of the pivot table summarizing all of these 7 cities under the factor 1, it first displays Cities 13, 22, 48 and 52 under the factor of 1, and then summarizes cities 49, 51 and 54 under (again) a factor of 1!!

Can someone kindly fix this? (I've attached the file for ease of reference)

DesperatePivot