How to remove all my duplicate values and combine certain cells

teza2k06 · #1 Yesterday, 06:48 AM

I have a spreadsheet with a large list of medications and the areas where they are kept. Each row shows a different area.

I want to remove all the duplicate values for the medications, but have all the areas combined into 1 cell separated by commas.

It might be a lot to ask, but can anyone help with the best way to do this

It will make the list a lot shorter (which I need), but will have all the locations together

I have attached an example of what I am after

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Combine "sort within groups" and "identify duplicate/unique values" in two different variables.	civilcervant	Excel	3	06-12-2017 07:27 AM
Combine documents makes duplicate word	vincelge	Word	2	05-15-2017 05:47 AM
How to remove duplicate vlookup values	suniltko	Excel	2	03-21-2017 10:52 AM
Combine values from different worksheets into a single worksheet.	jimmy2016	Excel	2	10-06-2016 09:15 AM
Compare & remove both sets of duplicate values	mummy	Excel	1	03-28-2016 02:59 AM