troubleshooting Question

ungroup column A and keep association to column B

Avatar of finnstone
finnstone asked on
Microsoft ExcelMicrosoft Office
11 Comments1 Solution207 ViewsLast Modified:
i have the attached file where column A has arrays like this separated by a semi colon.

https://www.barringtonortho.com/; https://www.mcpc.com/; https://www.nmortho.com/; https://www.orthocenter.com/; https://www.spinaldoc.com/; https://www.stmarysregional.com/; https://triangleortho.com/; http://www.trinitymedical.com.sg/

my goal is to create a new row with only one value in col A, but also associated it with the value in col B that was tied to the array
ASKER CERTIFIED SOLUTION
NorieSenior Associate
Join our community to see this answer!
Unlock 1 Answer and 11 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 11 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