View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
sek0910 sek0910 is offline
external usenet poster
 
Posts: 4
Default Make two colums from one column of data

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