Forum Discussion

mfseingim's avatar
mfseingim
Copper Contributor
Sep 10, 2023

How to convert more colums into a single one separated by ";"

Hi to everyone, here's an example of what I want to do:   I have three columns witch each three rows:   a1         b1          c1 a2         b2          c2 a3         b3          c3   I want...
excel
Patrick2788's avatar
Patrick2788
Silver Contributor
Sep 11, 2023

mfseingim 

If you're going to go with a LAMBDA, you might as well take it a bit further and make the source dynamic.

 

MyRange = A1:C10000

=LET(
    r, COUNTA(TAKE(MyRange, , 1)),
    dynamic, TAKE(MyRange, r),
    Join, LAMBDA(row, TEXTJOIN(";", , row)),
    BYROW(dynamic, Join)
)

 

 

 

Resources