How JustAnswer Works:

  • Ask an Expert
    Experts are full of valuable knowledge and are ready to help with any question. Credentials confirmed by a Fortune 500 verification firm.
  • Get a Professional Answer
    Via email, text message, or notification as you wait on our site.
    Ask follow up questions if you need to.
  • 100% Satisfaction Guarantee
    Rate the answer you receive.

Ask NewITZone Your Own Question

NewITZone
NewITZone, Computer Enthusiast
Category: Microsoft Office
Satisfied Customers: 90
Experience:  I have been using Office Pro for 10 years and implemented applications for business use.
53509759
Type Your Microsoft Office Question Here...
NewITZone is online now
A new question is answered every 9 seconds

Is there a formula to complete the following task: I have

Customer Question

Is there a formula to complete the following task:
I have the following data in 4 cells:
Year Make Model Item
2005-2008 Chevy Pickup Carpet
I want to create a separate line of data for each year, and duplicate the remaining data. So, after applying the formula, it would look like:
2005 Chevy Pickup Carpet
2006 Chevy Pickup Carpet
2007 Chevy Pickup Carpet
2008 Chevy Pickup Carpet
I have thousands of records, so it isn't feasible to do manually. Each record has a different range in years, and different data within the other cells.
Submitted: 3 months ago.
Category: Microsoft Office
Expert:  Kevin T replied 3 months ago.

Hi,

Could you tell me when you need this done by?

Regards

Kris

Customer: replied 3 months ago.
Not immediately. What is your timeline?
Expert:  Kevin T replied 3 months ago.

I could do it and document it for $99 (2 hours).

Customer: replied 3 months ago.
I think we will pass. Thanks anyways.