单独研究一下蛇形走位如何

wp231957

感觉自己写的太复杂了，这么多括号  眼睛都花了

=LET(data,B3:B18,_rows,INT((ROWS(data)+1)/2),a,WRAPROWS(data,2),DROP(REDUCE("",SEQUENCE(_rows,,0,1),LAMBDA(x,y,IF(MOD(y,2),LET(b,TAKE(DROP(a,y),1),VSTACK(x,HSTACK(TAKE(b,,-1),TAKE(b,,1)))),VSTACK(x,TAKE(DROP(a,y),1))))),1))

solextrade

=OFFSET($B$2,SMALL(ROW(A1)*2-{1,0},ABS(3*MOD(ROW(A2),2)-COLUMN(A1))),)

wp231957

solextrade 发表于 2024-11-21 10:31
=OFFSET($B$2,SMALL(ROW(A1)*2-{1,0},ABS(3*MOD(ROW(A2),2)-COLUMN(A1))),)

能用  你这个是横向纵向右拉下拉  厉害

leepoison

=LET(a,WRAPROWS(B3:B18,4),HSTACK(TOCOL(CHOOSECOLS(a,{1,4})),TOCOL(CHOOSECOLS(a,{2,3}))))

hxj119

1. =LET(arr,B3:B18,DROP(REDUCE("",SEQUENCE(ROUNDUP(ROWS(arr)/4,0),,0,4),LAMBDA(x,y,IFERROR(VSTACK(x,INDEX(arr,{1,2}+y),INDEX(arr,{4,3}+y)),""))),1))

复制代码

练习一下，公式略长。

wpsghost

=LET(data,B3:B18,arr,WRAPROWS(data,2),MAKEARRAY(ROWS(data)/2,2,LAMBDA(x,y,IF(MOD(x,2)=1,INDEX(arr,x,y),INDEX(arr,x,3-y)))))

hxj119

1. =LET(k,ISEVEN(ROW(A1)),CHOOSECOLS(TOROW(OFFSET($B$2,ROW(A1)*2-1,,2)),1+k,2-k))

复制代码

lachenfei

1. =REDUCE({"",""},B3:B18,LAMBDA(x,y,IF(ISODD(ROW(y)-ROW(B3)+1),IF(INT((ROW(y)-ROW(B3)+1+1)/4)=(ROW(y)-ROW(B3)+1+1)/4,VSTACK(x,HSTACK(OFFSET(y,1,0,1,1),y)),VSTACK(x,HSTACK(y,OFFSET(y,1,0,1,1)))),x)))

复制代码

能实现，但是会有一行空行

wp231957

lachenfei 发表于 2024-11-21 11:44
能实现，但是会有一行空行

外面再套一层drop就可以了

丢丢表格

我来献个丑：：：

=T(OFFSET($B$2,ROW(A1)*2-IF(MOD(ROW(),2),{1,0},{0,1}),))