Forum Discussion
Excel
Hello everyone! I need your help formatting rows in Excel. I have a large file with three rows. The content of the rows is text. These three rows must be combined to form one row in the following f...
Let's say first name is in A2 and down, last name in B2 and down, and email address in E2 and down. In the column where you want to combine them, in row 2:
=TEXTJOIN(", ", TRUE, A2, B2, E2)
Fill down.