title: Pull Apart Date Range into Separate Cells in CSV, Excel or Spreadsheet
body: <p>I have a set of dates (a range of years) for each car part in a spread sheet.  Each part has a different year range.  For example, a muffler fits a Ford Mustang from 1972-1977.  A mirror fits a Chevy Chevelle from 1969-1976.  There are 8,000 parts listed on the spreadsheet with date (year) ranges in a cell.  (The ranges are actually in two cells, first cell is starting year and second cell is ending year).  For each part, I need a listing (row) for each year in the range.  For example, the muffler for the Mustang would go from one row:<br /><br />
  1972-1977 | Ford | Mustang | Muffler <br /> <br />
  to six rows:<br /><br />
  1972 | Ford | Mustang | Muffler <br />
  1973 | Ford | Mustang | Muffler <br />
  1974 | Ford | Mustang | Muffler <br /><br />
  etc.  Can I extract these rows from the year range data already contained in the spreadsheet?  If so, how?<br />
  Thanks!</p>