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 be working.
Can someone help?
What I tried:
=Concat(c2,d2:c39,d39)
then
=concat(c2," ",d2) this was just to join first row of info
then tried the same function with concatenate.
2 Replies
Could you attach a small sample workbook demonstrating the problem (without sensitive data), or if that is not possible, make it available through OneDrive, Google Drive, Dropbox or similar? Provide a couple of examples to indicate what the result should look like.
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)))
