轉置 非空數據 (14509)

H2{=INDEX(A:A,SMALL(IF(MMULT(N(B$2:F$5>0),ROW(1:5)^0)>=COLUMN(A:Z),{2;3;4;5},9),ROW(A1)))&""

I2{=IF(H2="","",INDIRECT(TEXT(SMALL(IF(B$2:F$5>0,{2;3;4;5}/1%+{2,3,4,5,6}),ROW(A1)),"!R0C00"),))