Try,
1] Result Table put in E11:F16
2] F11, copied down :
=IFERROR(LARGE(INDEX($C$2:$I$6,MATCH($B$10,$B$2:$B$6,0),0),ROWS($1:1)),"")
3] E11, copied down :
=IF(F11="","",INDEX($C$1:$I$1,AGGREGATE(15,6,COLUMN($C$1:$I$1)-COLUMN($B$1)/(INDEX($C$2:$I$6,MATCH($B$10,$B$2:$B$6,0),0)=F11),COUNTIF(F$11:F11,F11))))
Regards
Bosco