Column Concatenation
this should do the trick if you are using T-SQL

select C1, C2, a.Chuck
from testa
right join  (select C1 as Chuck from testa UNION ALL select C2 as Chuck from testa) as a  ON a.Chuck = testa.C1