troubleshooting Question

Number Range expand question

Avatar of iceman19330
iceman19330 asked on
Microsoft Excel
13 Comments1 Solution291 ViewsLast Modified:
I have a spreadsheet that was given to me and it include zip code ranges with only the first 3 digits.  so in a column A1 004-005 and in column B1 it will have 2 or 3 or something like that.  Column A2 it might be 006-063 and B2 might be 3, while column A3 might be 008.  So what I am looking for is a way to break out the ranges into single rows so it would take A1 004-005 and then it would be A1 004 and A2 005 keeping the value of B1.  Is there a way to do that?  Right now my only option is to do it by hand and that could take a few hours to do.
ASKER CERTIFIED SOLUTION
wchh

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