How do I keep the same order when dragging the formula, I want A6 to be 3 and not 5.

CodePudding user response：

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")