How can i take every second value from a column

[Ipinho100]

Now the opponents are in different rows but i want them in different columns. How can i do that?

[bebo021999]

Try this:
G2:
=ROW(A1)
H2:
=INDEX($B$2:$B$1825,MATCH($G2,$A$2:$A$1825,0)+COLUMN(A:A)-1)
Copy down and accross

[Ipinho100]

Thank you!