非空三維資料 來回彙整 (13244)

A2:A9{=IFERROR(SMALL(IF((F$4:U$8>0)*(F$2:U$2>0),F$2:U$2),ROW(A1)),"")

B2:D9=IF($A2="","",OFFSET(E$3,COUNTIF($A$2:$A2,$A2),MATCH($A2,$F$2:$W$2,)))

F14:W17{=OFFSET($B$1,SMALL(IF($A$2:$A$9=LOOKUP(1,0/$F$12:F$12,$F$12:F$12),ROW($1:$8),99),ROW(A1)),MOD(COLUMN(C1),3))&""