Linking columns in a SQL table

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

linking fields in Sql Table

I need clarity.

linking fields in Sql Table

Ii need clarity