This screenshot shows a crosstab worksheet sorted on city.