make 3 columns into rows

[rodchar]

hey all,
is there a way to take an x amount of columns and automatically make the rows?

row1col1 row1col2 row1col3

into

row1col1
row2col2
row3col3


thanks,
rodchar

 

[Tim879]

copy the data -> Edit Paste Special -> Transpose

 

[rodchar]

thank you for your help,
rod.

copy the data -> Edit Paste Special -> Transpose

 

[Stig - tame racing driver]

not sure what you mean........ but try this

Copy - Special paste - and then tick transpose

Hope this helps