Hi,

Just change the references to column G to O in the formulas.

this in cell A3, copied down

=IF(COUNT(INDEX(Sheet1!$B:$B,MATCH(A2,Sheet1!$A:$A,0)):INDEX(Sheet1!$O:$O,MATCH(A2,Sheet1!$A:$A,0)))>COUNTIF($A$1:$A2,A2),A2,INDEX(Sheet1!$A:$A,MATCH(A2,Sheet1!$A:$A,0)+1))
this in cell B2, copied down

=INDEX(Sheet1!$A:$O,MATCH($A2,Sheet1!A:A,0),COUNTIF($A$2:$A2,$A2)*2)

this in cell C2, copied down

=INDEX(Sheet1!$A:$O,MATCH($A2,Sheet1!A:A,0),COUNTIF($A$2:$A2,$A2)*2+1)