Forum Discussion
Concat and Concatenate problem
I have 203 column of data that I need to merge each row of that data into one column - tyring to merge street names for a list of addresses. I ahve done this before but the function does not seem to ...
not sure what the question or problem is. the second formula should work for the first row and then fill down. CONCATENATE or TEXTJOIN functions would also work.
that said, for this simple case you can use:
=C2:C39 & " " & D2:D39
but if it is more complicated and a lot of columns your could
=BYROW(C2:D39, LAMBDA(r, TEXTJOIN(" ",,r)))