View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
sek0910
 
Posts: n/a
Default Making a second column from data in first column

I have a column of numbers, the first being a date and the second a value,
etc..
I want to take every other value (the even numbered rows) and move them to a
second column next to the date. Of course I'll end up with a blank every
other row, so I'll then want to "collapse" the columns to eliminate the
blanks.
Any easy way to do this as I have several thousand pieces of data.
Thanks in advance.,

Stephen