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?...
SergeiBaklan I have experienced the same issue (TEXTJOIN doesn't work) while attempting to combine data from 33 rows into a single row separated by a comma. Do you know of another method that does not require extensive data entry?
shayalynn , several ways without it
https://chandoo.org/wp/combine-text-values-quick-tip/
http://www.excelcampus.com/keyboard-shortcuts/concatenate-range-of-cells/
plus with PivotTable