Convert table with number ranges to numbers on each line

Hello,
I have this table with a list of day ranges and factors. It starts out with a single day, but then switches to ranges like 3 - 7, with a factor in the next column. Just looking for an easy way to put each day number on it's own line with the associated factor. Please see attached and it will be very clear what I'm trying to do.
Thanks!

You can put the heading "start" in C1 and this formula in C2:

=IF(ISNUMBER(A2),A2,--LEFT(A2,FIND("-",A2)-2))

Copy this down to the bottom of your data - it will give you the start day for each range. Then you can use this formula in cell G2:

=INDEX(B:B,MATCH(F2,C:C))

Copy this down as far as you need.

Hope this helps.

Pete

Great solution! Thank you very much!

Glad it worked for you - thanks for the rep.

If that takes care of your original question, please take a moment to select Thread Tools from the menu above and to the right of your first post in this thread, and mark the thread as SOLVED.

Pete