troubleshooting Question

Excel Macro to delete duplicate row based on column value...

Avatar of dcrowley_01
dcrowley_01Flag for United States of America asked on
Microsoft ExcelMicrosoft Applications
5 Comments1 Solution805 ViewsLast Modified:
I have a CSV file that is pipe delimited. I can only have one row per id. The entire column is not duplicated since the results are from an outer join but I can't have more than one result per ID so I just want to take the first result and delete the all others.

I looked at the Duplicate Master Add on, but since the rows aren't always exact I can't use it.

I am attaching a sample of data. So the basic idea would be to check the value before the first delimiter and delete any subsequent rows with that same id.




sample.csv
ASKER CERTIFIED SOLUTION
Glenn Ray
US Data Team Lead
Join our community to see this answer!
Unlock 1 Answer and 5 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 5 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros