• select Col

    from (select * from dbo.TESTTB) as X

    unpivot (Col for cols in (col1, col2, col3)) as Y