轉置 非空白 (9198)

G2:G5=LOOKUP(1,0/VLOOKUP($F2,$A:$D,{2,3,4},),$B$1:$D$1)

H2:H5=SUMPRODUCT(VLOOKUP($F2,$A:$D,{2,3,4},))

J2:K5{=INDIRECT(TEXT(MAX(IF(($B$2:$D$5>0)*($A$2:$A$5=$F2),{2;3;4;5}^(B$1=$C$1)/1%+{2,3,4})),"!R0C00"),)