Forum Discussion
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...
I take the solution a bit further than Patrick2788
Rather than creating a fill-down formula with relative referencing, I aim to create a single function that returns the entire list. Naming your data, 'dataArray', the processing may be done row by row using
= BYROW(dataArray, Joinλ)where Joinλ is a slightly more restrictive Lambda version of TEXTJOIN
= LAMBDA(x, TEXTJOIN(";", , x))I would upload a picture but, apparently I can no longer be allowed to upload pictures.
Thank you. It does help convey the message!