同一客户多行数据,怎么能合并到一起呢?表中共有几百个客户,求大神指导,谢谢(如图例)
è§æ ·è¡¨æªå¾
H2è¾å ¥
=IFERROR(LOOKUP(1,0/(($A$2:$A$11=$G2)*(B$2:B$11<>"")),B$2:B$11),"")
å ¬å¼å³æä¸æ