View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Tim879 Tim879 is offline
external usenet poster
 
Posts: 208
Default make 3 columns into rows

copy the data - Edit Paste Special - Transpose


On Nov 7, 9:31*am, rodchar wrote:
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