求助，怎么转换成右表的样子

补充，数字的部分实际应用中都是文本。其次数据量比较大，示例可能超过300个，怎么样效率会高

2025-03-29 11:52广告

用pq的逆透视

=DROP(REDUCE("",A1:A6,LAMBDA(x,y,VSTACK(x,VSTACK(HSTACK(REPTARRAY(OFFSET(y,,,,3),COUNTA(OFFSET(y,,3,,10))),TOCOL(OFFSET(y,,3,,10),3)))))),1)

=VSTACK({"分类1","分类2","分类3","示例"},TEXTSPLIT(CONCAT(IF(D2:G5="","",A2:A5&","&B2:B5&","&C2:C5&","&D2:G5&";")),",",";",1))

=LET(a,GROUPBY(A2:C4,D2:H4,IF({1,0},SINGLE,TOCOL(D1:H1)),,0),FILTER(a,TAKE(a,,-1)))

下载贴吧APP
看高清直播、视频！

分享到: