From: rodchar on
thanks for the help,
rod.

"rodchar" wrote:

> hi all,
>
> i'd like to take my single row result and turn selected columns into rows.
>
> id, col1, col2, col3
> ---------------------
> 1, 10,20,30
>
>
> Desired result:
>
> new1, new2
> ----------------
> col1, 10
> col2, 20
> col3, 30
>
> what's the easiest way to do this?
>
> thanks,
> rodchar