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. Thats using Primary Key Foreign Key for linking them

For example lets 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 field of the column making a new word south africa

I have no clue of how this can be done