create multiple column rows starting from data in one column

Alternatively, if you don't want to use macros, you could use the following formula in Cells B1 & C1 (assuming your lists starts in A1):

CELL B1
=OFFSET($A$1,ROW(A1)*2-ROW($A$1)*2,0)

CELL C1
=OFFSET($A$1,ROW(A1)*2-ROW($A$1)*2+1,0)

Cheers, Rob.