EXCEL from input using formulas / arrays?

Question

EXCEL question

The sample data is on the left -> how to achieve the expected result using excel?

Answer 1

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.