I want to reference every other cell doing down on the column next to it.
ie. i want the formula in b1 to =A1, b2 =A3, b3 =A5, b4 =a7, etc.. etc.. etc...

is there an easy way to do this instead of hand typing in all the forumlas