CodePudding user response：

Formula used to

I5 cell =UNIQUE(B5:B15)

J5 cell =@SORT(FILTER(FILTER($C$5:$F$15,$B$5:$B$15=$I5,""),$J$4:$M$4=J$4,""),1,-1)

Then drag down and across till need.