示意图如下：
如数据在D2:E100,在G2中输入公式：=IFERROR(INDEX($E$2:$E$89,SMALL(IF($D$2:$D$89=$D2,ROW($D$1:$D$88)),COLUMN(A$1))),"")&","&IFERROR(INDEX($E$2:$E$89,SMALL(IF($D$2:$D$89=$D2,ROW($D$1:$D$88)),COLUMN(B$1))),"")&","&IFERROR(INDEX($E$2:$E$89,SMALL(IF($D$2:$D$89=$D2,ROW($D$1:$D$88)),COLUMN(C$1))),"")&","&IFERROR(INDEX($E$2:$E$89,SMALL(IF($D$2:$D$89=$D2,ROW($D$1:$D$88)),COLUMN(D$1))),"") ，同时按下ENTER键，SHIFT键，和CTRL键，下拉。
K2=SUBSTITUTE(SUBSTITUTE(PHONETIC(OFFSET(D$1,MATCH(A2&D2,A$2:$A$99&D$2:$D$99,),,LOOKUP(,0/(A$2:A$99&D$2:$D$99=A2&D2),ROW($2:$99))-MATCH(A2&D2,A$2:$A$99&D$2:$D$99,),2)),D2,","),",","",1)
下拉
内容全部来源于网络收集，如有侵权，请联系网站删除：QQ：24596024