Get instant live expert help on convert column to comma separated list

“My Excelchat expert helped me in less than 20 minutes, saving me what would have been 5 hours of work!”

Post your problem and you’ll get expert help in seconds.

Our professional experts are available now. Your privacy is guaranteed.

Here are some problems that our users have asked and received explanations on

I need a formula to find duplicates from Column A to new Column with related data in comma separated manner Description - Column A has some duplicate values and its assocaited values are in Column B&C My requirement is to remove duplicate values from Column A and associated values should be moved into one cell with Comma separated
Solved by S. L. in 13 mins
I have a spreadsheet with a lot of columns and want a cell in each row that will have a comma-separated list of the columns that have data. Essentially, I think I need to create multiple "IF" functions within a cell that will output comma separated text based on whether a column is blank or not.
Solved by K. L. in 15 mins
In column A I have a list of duplicated values and in column B I have Unique values, I need a Formulato remove the duplicated value in column A and creates a comma separated value of removed value in Column B I need to attach the Excel files
Solved by X. H. in 20 mins
Hi. I need to join several cells into one and have it separated by a comma. For example, column g are all the clients on a list. cells g4 to g17 refers to a single client. Additionally, cells E4 to e17, refers to spare parts billed to this specific client. I need to be able to have all this spare parts on a single cell, and separated by a comma. This should be done for all columns. If the value is repeated (such as column g), a unique value should remain.
Solved by S. B. in 12 mins
I would like to take data from each cell and combine it into 1 cell separated by a comma (,)
Solved by I. F. in 21 mins