Merge multiple column values into one column in different table?
Try with union

insert into table2(column1)
select column1 from table1
union 
select column2 from table1
union
select column3 from table1