Thread: make 3 columns into rows
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
rodchar rodchar is offline
external usenet poster
  
Posts: 80
Default make 3 columns into rows
thank you for your help,
rod.

"Tim879" wrote:

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


Reply With QuoteReply With Quote