Combine data in 2 rows into 1 single row

HI
I got some data for tennis matches.
The data for each match is in 2 rows.

I would like to merge both the data into 1 column as shown in output tab(example).

Thank you in advance

See attached file, which shows the table in the Output sheet with the appropriate data. The formulae used are based around INDEX and MATCH, like this one in B2:

=IF($A2="","",INDEX('WTA-DATA'!$A:$M,ROWS($1:1)*2+1,MATCH(B$1,'WTA-DATA'!$A$2:$M$2,0)))

The ROWS term determines the row to get the data from, with either +1 or +2 (for player 2) as can be seen in the formulae further to the right. The first few columns also use the MATCH function, to determine from the headers which column to get the data from.

I've copied the formulae down to row 20, but you can copy them further if you have more data in the WTA-DATA sheet.

Hope this helps.

Pete

thank you both..nicely done

You're welcome, and thanks for the rep.

If that takes care of your original question, please take a moment to select Thread Tools from the menu above and to the right of your first post in this thread, and mark the thread as SOLVED.

Pete