How to Catalogue Data without having to input manually

Hello!

I have a long list of ports (and the list keeps changing) which I have to catalogue it according to countries.
Is there any way I can do this, whether using a macro or even tools already built into Excel such as V-lookup?

All help will be GREATLY APPRECIATED!

Have attached a copy of my excel as well. Thank you!