一二级目录下的表格转换题目，有图和附件。

宁两好饱 · 发表于 2025-12-9 16:17

如图，左表变成右表这样的一维表，欢迎各位大佬解答。

shaowu459 · 发表于 2025-12-10 07:47

=FILTER(MAP(B2:C12,LAMBDA(x,IF(x>"0",x,LOOKUP("座",B2:OFFSET(x,,1))))),B2:B12<"0")

你是那块小饼干 · 发表于 2025-12-9 16:56

=LET(T,SCAN(0,ISTEXT(B2:B12),SUM),REDUCE("",UNIQUE(T),LAMBDA(X,Y,LET(_T,FILTER(C2:C12,T=Y),VSTACK(X,IFNA(HSTACK(@_T,DROP(_T,1)),@_T))))))

alanyao168 · 发表于 2025-12-9 17:10

=FILTER(HSTACK(SCAN("",B2:B12,LAMBDA(x,y,IF(ISTEXT(y),OFFSET(y,,1),x))),C2:C12),ISNUMBER(B2:B12))

复制代码

fgq5910 · 发表于 2025-12-9 18:29

=FILTER(HSTACK(LOOKUP(ROW(B2:B12), IF(ISTEXT(B2:B12), ROW(B2:B12)), C2:C12), C2:C12), ISNUMBER(B2:B12))

今铭昔 · 发表于 2025-12-10 07:27

mao12306 · 发表于 2025-12-10 09:46

=LET(g,SCAN(0,B2:B12,LAMBDA(x,y,IF(REGEXP(y,"[一-龟]",1),x+1,x))),DROP(REDUCE(0,SEQUENCE(MAX(g)),LAMBDA(x,y,LET(t,FILTER(C2:C12,g=y),VSTACK(x,CHOOSE({1,2},@t,DROP(t,1)))))),1))

复制代码

A九月 · 发表于 2025-12-10 10:07

=LET(R,SCAN(0,B2:B12>99,SUM),DROP(REDUCE("",UNIQUE(R),LAMBDA(X,Y,VSTACK(X,LET(A,FILTER(C2:C12,R=Y),IF({1,0},@A,DROP(A,1)))))),1))

sucx007 · 发表于 2025-12-10 12:03

=DROP(REDUCE(0,C2:C12,LAMBDA(x,y,IF(OFFSET(y,,-1)>"a",x,VSTACK(x,HSTACK(IF(OFFSET(y,-1,-1)>"a",OFFSET(y,-1,),TAKE(x,-1,1)),y))))),1)

复制代码

comeet · 发表于 2025-12-11 11:14

=LET(f,LAMBDA(f,x,y,z,IF(x="",z,IF(ISTEXT(x),f(f,OFFSET(x,1,),OFFSET(x,,1),z),f(f,OFFSET(x,1,),y,VSTACK(z,HSTACK(y,OFFSET(x,,1))))))),f(f,B2,"",""))

复制代码

		自动登录	找回密码
密码			免费注册

[求助] 一二级目录下的表格转换题目，有图和附件。