Re-arrange data 'layout' in table

[outofservice]

I need to alter the way the data is stored within a table.

A typical row looks currently like this:

Col1 Col2 Col3 Col4
---- ------ ----- -----
XXXXX AAAAA BBBBB CCCCC

I need to 're-arrange' my table so that its displays thus:

Col1 Col2
---- -----
XXXXX AAAAA
XXXXX BBBBB
XXXXX CCCCC

Any ideas?
Lauryn Bradley
SQL Server DBA

 

[sunila7]

Hi,

does this help

select col1,col2 from #t
union all
select col1,col3 from #t
union all
select col1,col4 from #t


Sunil