Converting Columns to Rows???

[litalu]

I am hoping someone can help with the following:

I have a flat table as follows:

ID, Column1, Column2, Column3, etc.

And I need to get an output as follows

ColumnName, Value
-----------------
Column1, Value
Column2, Value
Column3, Value

Thanks.