Data from each row to 2 rows

[VAS07]

Hello everyone! I was wondering if someone can help me: I have a tab which is my data set that horizontally has some football games (so home team and away team are in the same row but different columns). I want in another tab to create the data set as follows: row 1 home team from 1st game, row 2 away team from 1st game, row 3 home team from the 2nd game, row 4 away team from the 2nd game etc.
when I put =and bring the cell back, when I drag down the function it misses rows from the original data set tab. so it brings back:
Row 1: home team from row 1 (correct)
Row 2:away team from row 1 (correct)
Row 3: home team from row 3 (wrong-I want the home team from row 2)
Row 4: away team from row 3 (wrong-I want the away team from row 2)

Any help will be much appreciated! Thank you!

 

[JamesCanale]

MrExcelPlayground12.xlsx
	A	B	C	D
1	Home	Away
2	Giants	Jets		Giants
3	Cowboys	Steelers		Jets
4	Oilers	Browns		Cowboys
5	Cardinals	Bears		Steelers
6	Dolphins	Chargers		Oilers
7				Browns
8				Cardinals
9				Bears
10				Dolphins
11				Chargers
Sheet22

Cell Formulas
Range	Formula
D2:D11	D2	=INDEX(A2:B6,INT((SEQUENCE(2*ROWS(A2:B6))-1)/2)+1,MOD(SEQUENCE(2*ROWS(A2:B6))-1,2)+1)
Dynamic array formulas.

 

[VAS07]

=INDEX(A2:B6,INT((SEQUENCE(2*ROWS(A2:B6))-1)/2)+1,MOD(SEQUENCE(2*ROWS(A2:B6))-1,2)+1)

Hello and thanks for your answer! I try to apply it in my version of excel dragging data from the other tab and keep getting an error:
=INDEX('2021-2022'!E2:F365;INT((SEQUENCE(2*ROWS('2021-2022'!E2:F365))-1)/2)+1;MOD(SEQUENCE(2*ROWS('2021-2022'!E2:F365))-1;2)+1)
Can you trace what is wrong?

 

[JamesCanale]

It doesn't need dragging. Just put it where you want the whole output column. It will spill.

 

[VAS07]

It doesn't need dragging. Just put it where you want the whole output column. It will spill.

 

[VAS07]

That's what I mean

 

[JamesCanale]

My guesses - you aren't running excel 2021 here, or commands in excel are different in different languages?

If you type "=INDEX(" into a cell, it should try to help you with the formula. Try that for INDEX, SEQUENCE, MOD, ROWS - to see what isn't recognized.