分组聚合

dongfangxielong

       将左边的表格通过公式变成右边的表格

inrever

1. =HSTACK(UNIQUE(A2:A23),MAP(UNIQUE(A2:A23),LAMBDA(m,TEXTJOIN(",",,LET(a,FILTER(B2:B23,A2:A23=m),MAP(UNIQUE(a),LAMBDA(n,n&"×"&SUM(N(a=n)))))))),MAP(UNIQUE(A2:A23),LAMBDA(t,SUM((A2:A23=t)*C2:C23))))

复制代码

博爱风雨同舟

=GROUPBY(A2:B23,C2:C23,HSTACK(ROWS,SUM),,2)
一步到位

飞天篮球猪

hugeinfo

=REDUCE({"ID账号","平台","成交量"},UNIQUE(A2:A23),LAMBDA(x,y,VSTACK(x,HSTACK(y,TEXTJOIN(",",,UNIQUE(BYROW(HSTACK(FILTER(B2:B23,A2:A23=y),COUNTIFS(B2:B23,FILTER(B2:B23,A2:A23=y),A2:A23,y)),LAMBDA(a,TEXTJOIN("x",,a))))),SUMIF(A2:A23,y,C2:C23))        )))

cnmlgb9998

飞天篮球猪 发表于 2024-8-29 13:21

你头像不是 超级马利64 的吗？ 换了？？？？？？？？

cnmlgb9998

借楼练一下PQ。


PQ 真的不香？？？？？？？？？？？？？？？？？

我要成为专家

1. =REDUCE(A1:C1,UNIQUE(A2:A23),LAMBDA(x,y,LET(s,FILTER(B:C,A:A=y),m,TAKE(s,,1),n,TAKE(s,,-1),VSTACK(x,HSTACK(y,TEXTJOIN(",",,UNIQUE(m&"×"&MMULT(--(m=TOROW(m)),SEQUENCE(ROWS(m))^0))),SUM(n))))))

复制代码

wps最新版

xiaoai007

1. =HSTACK(GROUPBY(A2:A23,B2:B23,LAMBDA(x,TEXTJOIN({"x",","},,GROUPBY(x,x,ROWS,,0))),,0),DROP(GROUPBY(A2:A23,C2:C23,SUM,,0),,1))

复制代码

你是那块小饼干

1. =LET(T,FILTER($B$2:$B$23,$A$2:$A$23=G2,""),_T,UNIQUE(T),HSTACK(REDUCE("",_T,LAMBDA(X,Y,TEXTJOIN(",",TRUE,VSTACK(X,CONCAT(Y,"X",SUM((Y=T)*1)))))),SUM(FILTER($C$2:$C$23,$A$2:$A$23=G2,"")*1)))

复制代码

下拉