TSQL or SSIS convert Columns into Rows -

could please suggest how achieve following? i.e. convert columns in rows using either tsql or ssis:

e.g. this:

col1    col2 start   end

to this:

start end

from this:

col1    col2    col3    col4 start   break   start   end

to this:

start break start break

thank you.

you can write results temporary table , transpose rows in table. solution of transposing in blog: http://sql-tricks.blogspot.com/2011/04/sql-server-rows-transpose.html

Expalin