Spreadsheet: 114703d1310436336-why-do-identical-values-show-up-twice-in-pivot-table-doubling-pivot
Sheet: Sheet1

Data |  |  |  | Pivot Table
 |  |  |  | Count of Name
Name | Factor |  |  | Factor | Name | Total
City 1 | 1.25 |  |  | 0.95 | City 33 | 1
City 2 | 1.25 |  |  |  | City 36 | 1
City 3 | 1.275 |  |  |  | City 44 | 1
City 4 | 1.3 |  |  |  | City 55 | 1
City 5 | 1.5125 |  |  |  | City 63 | 1
City 6 | 1.2875 |  |  | 0.9999999999999999 | City 13 | 1
City 7 | 1.2375 |  |  |  | City 22 | 1
City 8 | 1.275 |  |  |  | City 48 | 1
City 9 | 1.25 |  |  |  | City 52 | 1
City 10 | 1.3375 |  |  | 1 | City 49 | 1
City 11 | 1.5625 |  |  |  | City 51 | 1
City 12 | 1.35 |  |  |  | City 54 | 1
City 13 | 0.9999999999999999 |  |  | 1.025 | City 27 | 1
City 14 | 1.275 |  |  |  | City 50 | 1
City 15 | 1.3375 |  |  |  | City 66 | 1
City 16 | 1.5125 |  |  | 1.0375 | City 24 | 1
City 17 | 1.3375 |  |  |  | City 39 | 1
City 18 | 1.5875 |  |  | 1.05 | City 47 | 1
City 19 | 1.5625 |  |  | 1.175 | City 26 | 1
City 20 | 1.5625 |  |  |  | City 28 | 1
City 21 | 1.5625 |  |  |  | City 38 | 1
City 22 | 0.9999999999999999 |  |  |  | City 45 | 1
City 23 | 1.8625 |  |  | 1.2375 | City 7 | 1
City 24 | 1.0375 |  |  | 1.25 | City 1 | 1
City 25 | 1.3 |  |  |  | City 2 | 1
City 26 | 1.175 |  |  |  | City 9 | 1
City 27 | 1.025 |  |  | 1.275 | City 14 | 1
City 28 | 1.175 |  |  |  | City 3 | 1
City 29 | 1.3875 |  |  |  | City 8 | 1
City 30 | 1.35 |  |  | 1.2875 | City 62 | 1
City 31 | 1.7 |  |  | 1.2875 | City 6 | 1
City 32 | 1.7625 |  |  | 1.3 | City 25 | 1
City 33 | 0.95 |  |  |  | City 4 | 1
City 34 | 1.8 |  |  |  | City 40 | 1
City 35 | 1.8125 |  |  |  | City 42 | 1
City 36 | 0.95 |  |  |  | City 46 | 1
City 37 | 1.65 |  |  |  | City 56 | 1
City 38 | 1.175 |  |  |  | City 71 | 1
City 39 | 1.0375 |  |  | 1.3375 | City 10 | 1
City 40 | 1.3 |  |  |  | City 15 | 1
City 41 | 1.5625 |  |  |  | City 17 | 1
City 42 | 1.3 |  |  | 1.35 | City 12 | 1
City 43 | 1.4375 |  |  |  | City 30 | 1
City 44 | 0.95 |  |  |  | City 68 | 1
City 45 | 1.175 |  |  |  | City 70 | 1
City 46 | 1.3 |  |  | 1.3875 | City 29 | 1
City 47 | 1.05 |  |  | 1.4375 | City 43 | 1
City 48 | 0.9999999999999999 |  |  |  | City 53 | 1
City 49 | 1 |  |  | 1.5125 | City 16 | 1
City 50 | 1.025 |  |  |  | City 5 | 1
City 51 | 1 |  |  |  | City 64 | 1
City 52 | 0.9999999999999999 |  |  | 1.5625 | City 11 | 1
City 53 | 1.4375 |  |  |  | City 19 | 1
City 54 | 1 |  |  |  | City 20 | 1
City 55 | 0.95 |  |  |  | City 21 | 1
City 56 | 1.3 |  |  |  | City 41 | 1
City 57 | 1.8375 |  |  |  | City 61 | 1
City 58 | 1.8625 |  |  | 1.5875 | City 18 | 1
City 59 | 1.8625 |  |  | 1.6125 | City 67 | 1
City 60 | 1.8875 |  |  | 1.65 | City 37 | 1
City 61 | 1.5625 |  |  | 1.7 | City 31 | 1
City 62 | 1.2875 |  |  | 1.7625 | City 32 | 1
City 63 | 0.95 |  |  | 1.775 | City 65 | 1
City 64 | 1.5125 |  |  | 1.8 | City 34 | 1
City 65 | 1.775 |  |  | 1.8125 | City 35 | 1
City 66 | 1.025 |  |  | 1.8375 | City 57 | 1
City 67 | 1.6125 |  |  | 1.85 | City 69 | 1
City 68 | 1.35 |  |  | 1.8625 | City 58 | 1
City 69 | 1.85 |  |  |  | City 59 | 1
City 70 | 1.35 |  |  | 1.8625 | City 23 | 1
City 71 | 1.3 |  |  | 1.8875 | City 60 | 1
 |  |  |  | Grand Total |  | 71