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

Attached Files

example.xlsx (9.7 KB, 5 views)