Summarising Data

I have file in which I am trying to summarise the % allocated to each country. Most of the countries have distinct % allocations but for some reason a number of Countries have double entries and I can't work out when I use a summary table or a pivot table why the system is splitting some Country allocations into two.