合併格 取資料 (14473)

G2:H3{=INDEX($B:$B,SMALL(IF(IF($A$2:$A$5="",$A$1:$A$4,$A$2:$A$5)=$F2,ROW($2:$5),9),COLUMN(A1)))&""

N2:P5{=INDEX($K:$K,SMALL(IF(LOOKUP(ROW(2:9),ROW(2:9)/($J$2:$J$9<>""),$J$2:$J$9)=$M2,ROW($2:$9),99),COLUMN(A1)))&""