I've used the Transpose tool and then Summarize to group the city with 'Group by' and the column with all sales values to 'Sum' which has calculated the sum of all monthly sales data against each city.
I've used the Transpose tool and then Summarize to group the city with 'Group by' and the column with all sales values to 'Sum' which has calculated the sum of all monthly sales data against each city.