Q: what does the originalest data look like? You said output of your macro, implying that it's processed or reformated somehow
Q: I assume the cities have real names and not -nn numbers ("New York City", Los Angeles", "London", ...)
Q: I assume the metrics have real names ("Size", "Quality of Life", Good Fishing", ...)
Your basic premise (as I understand it) is to (A) compare two cities and 'grade' them against each other using various metrics (e.g. "LA vs NYC on size is 66")
It is NOT to (B) just 'grade' each city on the metrics (e.g. "LA on size is 66" and "NYC on size is 75")
I've never done it the A-way before, just the B-way