columns into rows

[qmann]

i want to take my columns and change them into rows. It dosen't seem to work with copying and pasting.. i try to paste and it just pastes another column. I know there is probably a simple fix but i can't put my finger on it. thanks for your help.

 

[santeria]

Paste Special Option to Transpose should do it...

And some additional details in this link:

http://www.mrexcel.com/board2/viewtopic.php?t=72165&highlight=columns+rows

 

[qmann]

excellent worked perfect.. thank you, i knew it was simple.