What is your exact requirement? Just transposing these columns to rows by itself makes no sense at all
Sounds like a pivot table - but - a fuller description of what you are trying to achieve would help?
OBIEE is great but still has no options for miracles ....
Even by hand in SQL you don't have a magical function doing that other than select each column and union all the result one after the other, so in OBIEE you also don't have magical solutions to that.
You can do the same UNION in the analysis itself if it's for just one or few analysis.
More in general this kind of things need to be managed on the data side, when creating a clean dimension in your ETL.
Thanks for all the help !