Hi Jen,
One way is to extract the odd and even cells to helper columns.
For example put the nimbers 1 to 20 in A1:A20
Then put this in B1
=INDEX(A:A,ROW()*2-1)
And this in C1
=INDEX(A:A,ROW()*2)
Grab the fill handle and drag both formulae down to Row 10.
That will leave all the odd numbers in column B
and all the even numbers in column C
HTH
Martin