How to combine two columns as one column with unique value

Hello,

I have so many columns on original table, I tried to merger both the tables, datas are duplicatiing. because it is whenever First column has value thne second column is empty and vice versa.

Is there way we can achieve thru query?

Avian