轉置表格 (13552)

K2{=INDEX(A:A,SMALL(IF(B$2:H$10,ROW($2:$10),99),ROW(A1)))&""

L2{=IFERROR(INDEX($1:$1,RIGHT(SMALL(IF(B$2:H$10,ROW($1:$9)/1%+COLUMN(B:H)),ROW(A1)),2)),"")

M2=IF(K2="","",SUMPRODUCT(B$2:H$10*(A$2:A$10=K2)*(B$1:H$1=L2)))