提取每列有尋找值 (9022)

I2下拉{=IFERROR(IF(ROW(A1)=1,""," ,")&INDEX($1:$1,SMALL(IF(MMULT({1,1,1,1,1,1},N(A$2:F$7=H$2)),COLUMN(A:F)),ROW(A1)))&I3,"")

另解=IFERROR(IF(ROW(A1)=1,""," ,")&INDEX($1:$1,SMALL(IF(COUNTIF(OFFSET(A$2:A7,,{0,1,2,3,4,5}),H$2),{1,2,3,4,5,6}),ROW(A1)))&K3,"")