Merging columns

New Contributor

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
you can use =A1:A100 & B1:B100 & C1:C100 or use the new Lambda function like: =BYROW(A1:C100, LAMBDA(r, CONCAT(r)))
Ok I will try that thanks