Link to home
Start Free TrialLog in
Avatar of Alistair_Mair
Alistair_Mair

asked on

Delete duplicate cell values in rows

Hi,
I have an excel spreadsheet with multiple colums and with all the records in rows. Some of the colums have duplicate value which i need to delete and have only one instance of the duplicate value appear in a single cell with all other unique values seperated by a comma as per the attached example.
DeleteRows.xlsx
Avatar of Patrick Matthews
Patrick Matthews
Flag of United States of America image

On Row 4 of your sample sheet, you list DOS - JOHN MASON twice, and your sample output for that row lists that entry twice.

Then, on Row 10, you list DOS - JOHN MASON twice again, but your sample output for that row lists that value once but then for some odd reason lists SP-100 - LAUREL WEINER twice.

I think you need to take another crack on defining your requirements :)
Avatar of Alistair_Mair
Alistair_Mair

ASKER

Revised file as per your comment, apologise for the confusion.
DeleteRows.xlsx
ASKER CERTIFIED SOLUTION
Avatar of Patrick Matthews
Patrick Matthews
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Many thanks for your help, much appreciated.