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.