=SUM(--(UNIQUE($B$2:$B$20)>=B2))=TEXTJOIN(",",,FILTER($A$2:$A$20,$C$2:$C$20=E2))=INDEX($B$2:$B$20,MATCH(E2,$C$2:$C$20,0))=GROUPBY(B2:B20,A2:A20,ARRAYTOTEXT,0,0,-1)=GROUPBY (row_fields，values，function，[field_headers]，[total_depth]，[sort_order]，[filter_array])=GROUPBY(行字段，值，汇总方式，[是否包含标题]，[是否显示总计小计]，[排序依据]，[筛选依据])
=GROUPBY(B2:B20,A2:A20,ARRAYTOTEXT,0,0,-1)=GROUPBY(B2:B20,A2:A20,LAMBDA(s,TEXTJOIN("、",,s)),0,0,-1)each Text.Combine([姓名],"、")分组依据 更改汇总方式 Text.Combine 将业绩进行降序 添加索引列，从 1 开始
