Ideas" to convert Horizontal to Vertical

[HotRod]

I want to setup my excel spread sheet a sideways so that I can import the
data properly into a different program. This means that all of the data in
ROW 1 would become COLUMN A etc. etc. What is the best way to reference all
the data from another sheet and put it onto the new sheet? Can I do this
without a macro?

[Niek Otten]

Edit>Paste Special>Transpose

--
Kind regards,

Niek Otten

"HotRod" <[email protected]> wrote in message
news:[email protected]...
>I want to setup my excel spread sheet a sideways so that I can import the
>data properly into a different program. This means that all of the data in
>ROW 1 would become COLUMN A etc. etc. What is the best way to reference all
>the data from another sheet and put it onto the new sheet? Can I do this
>without a macro?
>

[HotRod]

And my new best friend is. Niek , Thanks