sukuye.jerry wrote:請大神幫忙(恕刪) C2:=IF(B2=1,TEXTJOIN(C H A R (10),, IF ($A$1:$A$100=A2,$B$1:$B$100,"")),"")向下複製公式到C3:C16