轉置 多維 (14811)

I6:J8=SUMIF($C$5:$H$5,I$5,$C6:$H6)

L5{=IFERROR(INDEX(B:B,SMALL(IF(C$6:H$8>0,{6;7;8}),ROW(A1))),"")

M2{=IF(L5="","",OFFSET(B$4,,SMALL(IF(VLOOKUP(L5,B:H,COLUMN(B:G),)>0,INT((COLUMN(B:G))/2)*2-1),COUNTIF(L$5:L5,L5))))

N5{=IF(L5="","",INDEX($5:$5,SMALL(IF(VLOOKUP(L5,B:H,COLUMN(B:G),)>0,COLUMN(C:H)),COUNTIF(L$5:L5,L5))))

O2{=IF(L5="","",RIGHT(SMALL(IF((B$6:B$8=L5)*(C$6:H$8>0),COLUMN(C:H)*10^7+C$6:H$8),COUNTIF(L$5:L5,L5)),7)*1)