Dragging a formula that increases in count, but doesn't skip

I'm sure there's an easier way to do this, but if not can you help with what I'm trying my best to fix!

I have two rows of data, A+B. It goes to B500. This data is pulled from another data set by a formula and can be blank.

I need them to be combined into one row, using a formula so instead of:

eggs - milk
chalk - gammon
peas - suits

it will read

eggs
milk
chalk
gammon
etc

I've tried copying dragging A1, B1, A2, B2 etc down but it skips rows and restarts on whatever row it's on. Any idea?

Try

=INDEX(A$1:B$500,(ROWS(A$1:A1)-1)/2+1,MOD(ROWS(A$1:A1)-1,2)+1)

Originally Posted by Jonmo1

Try

=INDEX(A$1:B$500,(ROWS(A$1:A1)-1)/2+1,MOD(ROWS(A$1:A1)-1,2)+1)

This worked perfectly thanks!!

You're welcome.