Forum Discussion
drop down list
Excel Spread sheet: Column: a b c d row 1 xy 21 2 ts 13 when I key : =a1, it show "xy" =b1, it show "21" ...
If you start from first row, in first cell =A1, in second one
=OFFSET($A$1,INT((ROW()-1)/2),MOD(ROW()-1,2))
and drag it down.
Attached