轉置 表格 (10435)

K2:P6=LOOKUP(,0/MMULT(($B$2:$B$15=$J2)*($C$2:$H$15=K$1),ROW($1:$6)^0),$A$2:$A$15)

另解=INDEX($A:$A,SUMPRODUCT(($C$2:$H$15=K$1)*($B$2:$B$15=$J2)*ROW($2:$15)))