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

If your data starts in A1:
=INDIRECT("A"&(ROW()-1)*2+2)
Regards
Hans


"sek0910" <[email protected]> skrev i en meddelelse news:[email protected]...
>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

Hi Stephen,

For a programmatic solution, see suggestion in Programming.


---
Regards,
Norman



"sek0910" <[email protected]> wrote in message
news:[email protected]...
>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