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?...
TEXTJOIN doesn't work since you don't have it (you are not Office365 subscriber) or that's something else?
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
