助各位大神，请问怎么把第二行放到一列里？

ken8549

求助各位大神，请问怎么把第二行放到一列里？

leepoison

偷一下
=LET(a,B3:J14,HSTACK(TOCOL(IF(a,A3:A14)),TOCOL(IF(a,B2:J2),,1),TOCOL(a,,1)))
强壮一点
=HSTACK(REPTARRAY(A3:A14,COUNTA(B2:J2)),TOCOL(REPTARRAY(B2:J2,COUNTA(A3:A14)),,1),TOCOL(B3:J14,,1))

theking_wsz

=DROP(REDUCE("",B2:J2,LAMBDA(x,y,VSTACK(x,IFNA(HSTACK(A3:A14,y,OFFSET(A3:A14,,MATCH(y,B2:J2,))),y)))),1)

秃头发师

=LET(fx,LAMBDA(x,HSTACK(A3:A14,EXPAND(x,12,,x),OFFSET(x,1,,12))),
     REDUCE({"合计","",""},B2:J2,LAMBDA(a,b,VSTACK(a,fx(b)))))

ken8549

秃头发师 发表于 2025-12-11 10:38
=LET(fx,LAMBDA(x,HSTACK(A3:A14,EXPAND(x,12,,x),OFFSET(x,1,,12))),
     REDUCE({"合计","",""},B2:J2, ...

非常感谢！

comeet

1. =REDUCE({"合计","",""},B2:J2,LAMBDA(x,y,VSTACK(x,HSTACK(A3:A14,EXPAND(y,12,,y),OFFSET(y,1,,12)))))

复制代码

fjh19880625

偷学一下
=LET(a,OFFSET(A2,1,1,12,COUNTA(2:2)-1),HSTACK(VSTACK("期间",TOCOL(IF(a,A3:A14),,1)),VSTACK("地区",TOCOL(IF(a,OFFSET(A2,,1,,COUNTA(2:2)-1)),,1)),VSTACK("数据",TOCOL(a,,1))))

你是那块小饼干

=GROUPBY(A3:A14,B3:J14,IF({1,0},SUM,TOCOL(B2:J2)),0,0)

fgq5910

=LET(
    fx, LAMBDA(x, HSTACK(A3:A14, EXPAND(x, ROWS(A3:A14), , x), OFFSET(x, 1, 0, ROWS(A3:A14), 1))),
    REDUCE({"合计","",""}, B2:J2, LAMBDA(a, b, VSTACK(a, fx(b))))
)

人有言兮是然

话说，这个题反向出，一个函数搞定。题目这种好像还没有一个函数搞定的，稍微复杂点点。

1. =LET(mr,A3:A14,dr,B2:J14,rn,COUNTA(mr),cn,COLUMNS(dr),HSTACK(REPTARRAY(mr,cn),TOCOL(REPTARRAY(TAKE(dr,1),rn),,1),TOCOL(DROP(dr,1),,1)))

复制代码