EXCEL中如何将A列相同数据所对应的C列数据合并至一个单元格，并且数据间用逗号隔开。公式看不全，请供完整

=SUBSTITUTE((SUBSTITUTE(PHONETIC(OFFSET($A$1,MATCH(E2统,$A$1:$A$1000,0来自)-1,,MATCH(E2,$A$1:$A重氢立活异渐$1000)-1,3)),E2,",")),",","",1)