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

Copy - Special paste - and then tick transpose

Hope this helps


"rodchar" wrote in message
...
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