Merging columns

[DamdisA]

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]

you can use =A1:A100 & B1:B100 & C1:C100 or use the new Lambda function like: =BYROW(A1:C100, LAMBDA(r, CONCAT(r)))

[#3]

Ok I will try that thanks