本帖最后由 mjm04 于 2025-3-21 10:47 编辑
区域数组，一步到位的
用了WPS正则， M365要换正则函数名 或 TEXTSPLIT
=HSTACK(DROP(REDUCE("",TOCOL(IF(Orginal!$G$2:$Y$20<>"",BYROW(Orginal!$A$2:$F$20,LAMBDA(a,TEXTJOIN("@",,a))),AA),3),LAMBDA(a,b,VSTACK(a,REGEXP(b,"[^@]+")))),1),TOCOL(IF(Orginal!$G$2:$Y$20<>"",Orginal!$G$1:$Y$1,AA),3),TOCOL(IF(Orginal!$G$2:$Y$20<>"",Orginal!$G$2:$Y$20,AA),3))
=============================================================
TEXTSPLIT 的
=HSTACK(DROP(REDUCE("",TOCOL(IF(Orginal!$G$2:$Y$20<>"",BYROW(Orginal!$A$2:$F$20,LAMBDA(a,TEXTJOIN("@",,a))),AA),3),LAMBDA(a,b,VSTACK(a,TEXTSPLIT(b,"@")))),1),TOCOL(IF(Orginal!$G$2:$Y$20<>"",Orginal!$G$1:$Y$1,AA),3),TOCOL(IF(Orginal!$G$2:$Y$20<>"",Orginal!$G$2:$Y$20,AA),3))
|
楼主: Kuang366
沪公网安备 31011702000001号 沪ICP备11019229号-2
发表于 2025-2-10 11:29
