There are no Excel formulas that will do what you are asking. It may be possible using VBA, but for that you will need someone with programming skill. You could also do it using Microsoft Access, but that would mean changing a basic list into a database.

The simplest solution would be to rearrange your list so that there is only one country per row.

Cheers,