Cell C10 formula , Drag down and across

Formula: copy to clipboard
=IFERROR(INDEX($2:$2,AGGREGATE(15,6,COLUMN($D$2:$N$2)/(($A$3:$A$5=$A10)*($D$3:$N$5=1)),COLUMN(A$1))),"")