copying pattern from one column to another

the answer to this question is probably simple but I'm stumped...

I need to copy the data from the odd-numbered (or even) rows of one column into another column consecutively.

For example: column A into column B

column A column B
1 1
3 2
5 3
7 4
9 5
. 6
. 7
. 8
. 9

i tried typing in =B1, =B3, and =B5 into the first 3 rows and dragging the pattern but that doesn't work.

Hi,

I typed into A1 this formula:

=INDIRECT((ADDRESS(ROW()*2-1,2)))

and dragged down with the crosshair.

It works.

Is It what you wanted?

Kaus

Yes, that was exactly what I needed. Thanks!