Transforming Data to Another Sheet

Please try this,

Helper at P2:Px
=INDEX('My Data'!$B$2:$B$30,MATCH(0,INDEX(COUNTIFS(P$1:P1,'My Data'!$B$2:$B$30),),))&""

A2
=IF($C2="","",MATCH($C2,$P$2:$P$10,))

B2, E2, F2 change index array
=IF($C2="","",INDEX('My Data'!A$2:A$30,MATCH($C2,'My Data'!$B$2:$B$30,),))

C2
=IFERROR(INDEX($P$2:$P$4,MATCH(1,INDEX(N(COUNTIF(C$1:C1,$P$2:$P$4)< MMULT(COUNTIFS('My Data'!$B$2:$B$20,$P$2:$P$4,'My Data'!$H$2:$H$20,{"< >",""}),{2;1})-1),),)),"")

The rest in attached