how to make a list to avoid repetitive texts

Before anything else, I want to say that I am beginner level in VBA so I hope somebody could help me figuring out the best solution on this.

Background:
This will be a database of problems occurring in the company i am working with and we want to have a database to find the contact person easier depending on the problem (see column D and E)

My Problem:
Data are the same in every group (countries in every region), I want it to be user friendly and not make the database very long because if I will continue copy - paste the same texts, I would probably be using 5000 rows