I need clarity. Is there a way to link values from a column or columns to make an entry in another column?

For example imagine I had a table with the names column and this column has words such as [south, africa, america…] and I wanted to link this to a table were I can merge 2 values from the names column to one column called Country and make a merged value such as “South Africa”.

Two words from the same column creating a new word in another. That’s using primary key foreign key for linking them

For example, let’s say a unique id for “South” is 1 and for “Africa” is 2 and for “America” is 3, can I link the values 1-2 to the same entry same column of the column making a new word “South Africa” ?

I have no clue of how this can be done