How do I keep the same order when dragging the formula, I want A6 to be 3 and not 5.
>Solution :
Use the following formula instead of =B1
=INDEX(B$1:B$10,ROW()/2)
If you want to populate the entire column withjust a formula, then this should do the trick:
=IF(ROW()/2 = ROUND(ROW()/2,0),INDEX(B$1:B$10,ROW()/2),"name")
