Forum Discussion

DamdisA's avatar
DamdisA
Copper Contributor
Jun 30, 2022

Merging columns

I am trying to merge customer emails, phone #'s and addresses into one column. I can do it if I only have one row but with multiple customers and different contact info I can't??? Is that possible 

2 Replies

  • mtarler's avatar
    mtarler
    Silver Contributor
    you can use =A1:A100 & B1:B100 & C1:C100 or use the new Lambda function like: =BYROW(A1:C100, LAMBDA(r, CONCAT(r)))

Resources