please see attached spreadsheet.
in each color block, the part number matches, but the Year Ranges do not always.
the new sheet must list the part number 1 time on 1 row with the minimum Year and the maximum Year data as shown in the attached sheet.
the full sheet has many rows which do not have duplicates and can remain unchanged in the new sheet.
$40 dollars
if this job goes well, i have a more advanced job combining this new year range data into another sheet which will pay around $250 dollars.