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!”
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