彙整成單元格 (11762)

D2右拉 下拉{=IFERROR(IF(COLUMN(A1)=1,$D$1&"-(",",")&INDEX(MID($A$1:$C$1,2,LEN($A$1:$C$1)-2)&$A2:$C2,SMALL(IF($A2:$C2>0,COLUMN($A:$C)),COLUMN(A1)))&IF(COLUMN(A1)=COUNTA($A2:$C2),")","")&E2,"")