Hi..

I am quering an oracle table which returns 1 row of 5 data elements. I want
to display it horizontally (say in cells A1:A5). I know I can transpose it
but I was wondering if there was a way I could do the conversion to a
vertical list without having to first put it somewhere on the worksheet and
then doing the transpose operation?

I apologize for being such a rookie but your help would greatly be
appreciated.