Forum Discussion
Combine data from multiple rows into a single row separated by a comma and space
I have a lot of data I'll need to move from one column into one single cell separated by comma space. The data is letters and numbers. I've tried the TEXTJOIN feature and it's not working. Any ideas?...
Combine data in 3 rows of column A into one field separated by commas:
A1: ab
A2: cd
A3: ef
1. In B1 enter function: =concat(a1,", ") and copy function to all rows below. Results:
B1: ab,
B2: cd,
B3: ef,
3. Copy column B and Paste Values to column C
4. In D1, enter function =concat(C1:C3). Results: ab, cd, ef
5. Copy D1 and Paste Values to E1.