Summarizing Data with Pivot Table

I have a small problem with pivot tables I want to group data per tags. For example I have a list showing the cities and the countries they are located. I want to see the grouping in different columns; please refer to attachement for further details.

Sorting does not work my special purpose. I am trying to create a dynamic table.

Any explanation on how you construct the pivot table will be much appreciated.