Formula to return every nth cell in a column

[emg48]

I want to return every other cell in a column, and return the remaining cells(also every other) in an adjacent column. I cannot have empty cells in between numbers due to the functions I am using.

For example,
A formula to take:
1
2
3
4
5
6

and return:
1 2
3 4
5 6

Don't know if this is possible but would appreciate any thoughts(can't use sort because the data refreshes to every other line from an outside source)

[MarvinP]

Hi emg48 and welcome to the forum,

See the attached for your answer. The hint is using Indirect and a Row() number to return the correct value from column A.