A表转换成B表，数据转换分行，数组公式

小希123 · 发表于 2025-12-17 10:26

=REDUCE(A3:B3,A4:A6,LAMBDA(x,y,VSTACK(x,IFNA(HSTACK(y,TEXTSPLIT(OFFSET(y,,1),,",")),y))))

cnppp · 发表于 2025-12-17 10:49

=HSTACK(
TOCOL(IF(TEXTSPLIT(TEXTJOIN(";",TRUE,B4:B6),",",";")<>"",A4:A6,""),2),
TOCOL(TEXTSPLIT(TEXTJOIN(",",TRUE,B4:B6), ,","),1) )

mengrs · 发表于 2025-12-17 10:55

=REDUCE(A3:B3,OFFSET(A4,,,COUNTA(A:A)-2),LAMBDA(x,y,VSTACK(x,CHOOSE({1,2},y,TEXTSPLIT(OFFSET(y,,1),,",")))))

志在 · 发表于 2025-12-17 11:26

可以用，谢谢大家

你是那块小饼干 · 发表于 2025-12-17 13:38

=REDUCE("",A4:A6,LAMBDA(X,Y,VSTACK(X,IFNA(HSTACK(Y,TEXTSPLIT(OFFSET(Y,,1),,",")),Y))))

一杯绿茶来了 · 发表于 2025-12-17 14:33

=REDUCE(D3:E3,A4:A6,LAMBDA(x,y,VSTACK(x,IF({1,0},y,TEXTSPLIT(OFFSET(y,,1),,",")))))

lisongmei · 发表于 2025-12-17 16:14

=REDUCE({"订单号","出库单号"},B4:B6,LAMBDA(y,x,VSTACK(y,HSTACK(EXPAND(OFFSET(x,0,-1),COUNTA(TOCOL(TEXTSPLIT(x,","))),1,OFFSET(x,0,-1)),TOCOL(TEXTSPLIT(x,","))))))

mjm04 · 发表于 2025-12-17 16:40

本帖最后由 mjm04 于 2025-12-17 16:46 编辑

=LET(m,DROP(IFNA(REDUCE("",REGEXP(B4:B6,"[^,]+",3),VSTACK),""),1),fx,LAMBDA(a,TOCOL(IF(m<>"",a,AA),3)),HSTACK(fx(A4:A6),fx(m)))

或
=REDUCE(A3:B3,A4:A6,LAMBDA(a,b,VSTACK(a,IFNA(HSTACK(b,TOCOL(REGEXP(OFFSET(b,,1),"[^,]+",3),3)),b))))

9999剑 · 发表于 2025-12-17 17:29

=REDUCE(A3:B3,B4:B6,LAMBDA(x,y,VSTACK(x,IF({1,0},OFFSET(y,,-1),TEXTSPLIT(y,,",")))))

复制代码

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

[求助] A表转换成B表，数据转换分行，数组公式