Try,
1] In B1, copied across right to F1:
=IFERROR(INDEX(Sheet1!$B$2:$B$35,MATCH(0,INDEX(COUNTIF($A1:A1,Sheet1!$B$2:$B$35),0),0)),"")
2] In B2, copied across right to F2:
=IFERROR(INDEX(Sheet1!$C$2:$C$35,MATCH(B1,Sheet1!$B$2:$B$35,0)),"")
3] In B3, copied across right to F3 and all copied down :
=IFERROR(AGGREGATE(14,6,Sheet1!$A$2:$A$35/(Sheet1!$B$2:$B$35=B$1),ROWS($1:1)),"")
Regards
Bosco