将竖列内容分组后变为横排显示

mengrs

=TEXTSPLIT(TEXTJOIN(",",1,SUBSTITUTE(Sheet1!A1:A99,"#","@#")),",","@",1,,"")

fs5267

苏小亓 发表于 2025-4-1 11:29
能力有限只能做这样的。

好的。谢谢。我试试看

mengrs

=TEXTSPLIT(CONCAT(SUBSTITUTE(Sheet1!A1:A99,"#","@#")&","),",","@",1,,"")

fs5267

无关岁月 发表于 2025-4-1 11:42
火车来了

谢谢。我试试看

fs5267

紫川文秀 发表于 2025-4-1 11:43
=LET(arr,TEXTSPLIT(TEXTJOIN("|",,FILTER(A:A,A:A"")),,"#"),brr,"#"&FILTER(arr,arr""),IF(RIGHT(brr)="| ...

好的。谢谢

fs5267

yzfsz 发表于 2025-4-1 11:47
生堆出来的
=LET(X,VSTACK(SCAN(0,IF(LEFT(TOROW(A:A,3),1)="#",1,0),LAMBDA(a,b,a+b)),TOROW(A:A,3)),FIL ...

每个订单的最后两项能从指定列开始排列吗？比如从M列。

hxj119

1. =LET(a,TOCOL(IF(Sheet1!A1:A999<>"",Sheet1!A1:A999,0/0),3),b,SCAN(0,a,LAMBDA(q,w,IF(REGEXP(w,"#",1),q+1,q))),DROP(REDUCE("",UNIQUE(b),LAMBDA(x,y,LET(c,FILTER(a,b=y),IFNA(VSTACK(x,TOROW(VSTACK(EXPAND(DROP(c,-4),12,,""),TAKE(c,-4)))),"")))),1))

复制代码

fs5267

快乐王子238 发表于 2025-4-1 12:05
加我13797169385给你公式

好的。。。。。。。。。。。。

fs5267

你是那块小饼干 发表于 2025-4-1 11:59
=LET(T,SCAN(0,Sheet1!A1:A67,LAMBDA(X,Y,IF(ISNUMBER(FIND("#",Y)),X+1,X))),REDUCE("",UNIQUE(T),LAMBDA( ...

谢谢。我试试看

fs5267

mengrs 发表于 2025-4-1 12:19
=TEXTSPLIT(TEXTJOIN(",",1,SUBSTITUTE(Sheet1!A1:A99,"#","@#")),",","@",1,,"")

我试一下。谢谢