We run a car parts e-commerce store and use vendor-supplied spreadsheets to import product information. Our website has been changed so that when importing product information, the part applications (which vehicles the part fits) must use a range for years ("2004-2011".) The spreadsheets are given to us with each year in its own row, meaning there are multiple lines with the same part number, make and model with only differing years. Please see the spreadsheet I attached for better clarification, on the left is how the spreadsheets are given to us and on the right is how it needs to look.

Can someone please point me in the right direction for how I might go about manipulating the data to fit into the new required format? I don't have much experience with Excel but I was thinking something along the lines of grouping together the rows with matching part numbers, make and model and then taking the lowest year value and the highest year value in that group to make the range (2004-2011), if that makes sense.

Any and all help is greatly appreciated!