班級相同 聚單元格 (11901)

D2:D16=IFERROR(LOOKUP(1,0/(B$1:B1=B2),D$1:D1)&",","")&C2

G2:G5=LOOKUP(1,0/(B$2:B$16=F2),D$2:D$16)

G11{=IFERROR(IF(COLUMN(A1)=1,"",",")&INDEX($C:$C,SMALL(IF($B$2:$B$16=$F11,ROW($2:$16)),COLUMN(A1)))&H11,"")