insert into tb2 (select col1 from tb2 union all select col2 from tb2 union all select col3 from tb2 union all select col4 from tb2 union all select col5 from tb2)
insert table2
select col1 from tabel1 union all
select col2 from tabel1 union all
select col3 from tabel1 union all
select col4 from tabel1 union all
select col5 from tabel1
insert into Table2(newCol) select col1 from Table1
union all select col2 from Table1
union all select col3 from Table1
union all select col4 from Table1
union all select col5 from Table1
insert into tb1
select * from
(
select col1 from tb union all
select col2 from tb union all
select col3 from tb union all
select col4 from tb union all
select col5 from tb
) t order by col1
create table tb(col1 int , col2 int , col3 int , col4 int , col5 int)
insert into tb values(1,2,3,4,5)
insert into tb values(6,7,8,9,10)
insert into tb values(11,12,13,14,15)
insert into tb values(16,17,18,19,20)
go
select * from
(
select col1 from tb union all
select col2 from tb union all
select col3 from tb union all
select col4 from tb union all
select col5 from tb
) t order by col1