troubleshooting Question

combine two columns if same value

Avatar of finnstone
finnstone asked on
VBAMicrosoft ExcelMicrosoft Office
13 Comments1 Solution256 ViewsLast Modified:
i DOCID  in column A

1111111111
44444
44444
8888888


in column AO
experience.organization.name - Behavioral
experience.organization.name - psych
experience.organization.name - Behavioral
experience.organization.name - Behavioral
 


I want to combine the values in AO where the values are the same in column A

so values would become this (only need to do it for the first one)

experience.organization.name - Behavioral
experience.organization.name - psych, experience.organization.name - Behavioral
experience.organization.name - Behavioral,
experience.organization.name - Behavioral


NOTE, it is sorted on column A , and the tricky part is some have 3 matches, other have 4, 5 , 6 etc

I WOULD ALSO need a value put in column AP so i know which rows got appended more data
ASKER CERTIFIED SOLUTION
Neil Fleming
Consultant and developer

Our community of experts have been thoroughly vetted for their expertise and industry experience.

Join our community to see this answer!
Unlock 1 Answer and 13 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 13 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