1列转化为多列遇到的问题

q1a2z3q1a2z3

1列转化为多列遇到的问题

pgp5866

1. =LET(r,GROUPBY(LEFT(A2:A13,3),A2:A13,TOCOL,0,0),REDUCE(,DROP(r,,1),HSTACK))

复制代码

沈默00

=SORT(WRAPROWS(A2:A13,4),1)

wdy895

=LET(x,SORT(WRAPROWS(A2:A13,4)),HSTACK(TAKE(x,,2),CHOOSECOLS(x,3)&CHOOSECOLS(x,4)))
只会笨办法，供参考。

jivy1212

1. =SORT(MID(CONCAT(WRAPROWS(A2:A13,4,3)),{1,10,18}+{0;27;54},{9,8,10}))

复制代码

限示例

无关岁月

1. =SORT(WRAPROWS(REGEXP(CONCAT(IF(LEN(A2:A13)>6,","&A2:A13&",",A2:A13)),"[^,]+"),3))

复制代码

秃头发师

=LET(x,WRAPROWS(A2:A13,4),HSTACK(TAKE(x,,2),CHOOSECOLS(x,3)&CHOOSECOLS(x,4)))

hugeinfo

=LET(a,SORT(WRAPROWS(A2:A13,4),1),HSTACK(TAKE(a,,2),BYROW(TAKE(a,,-2),LAMBDA(x,CONCAT(x)))))

A九月

=CHOOSEROWS(LET(ARR,WRAPROWS(A2:A13,4),HSTACK(CHOOSECOLS(ARR,1,2),CHOOSECOLS(ARR,3)&CHOOSECOLS(ARR,4))),2,1,3)

快乐王子238

你已经做出来了，取后面两列，cancat即可