I have a table that has information for locations. The locations are have both address and country info. The labels are listed in order by count, and not all locations are listed for each location. A sample table is attached. The real table has 73 countries, and 40 labels.

For simplicity, this is a sample table with 3 countries and 4 labels:

This is how my table is structured:

enter image description here

This is the output I would like:
enter image description here