Elayaz: many thanks for your effort. What you have on the second sheet is actually what I am looking to get in the end. However because the actual file is so extensive, I cannot manually combine the year ranges for every car. That is what I would like Excel to do for me.

The underlying idea is that we want to use the end product as a kind of address list to make advertisement texts with in Word, using the excel sheet to generate the titles per car model. So in order to make that work I need to end up with a file that has 1 car model / engine combination per row with the range of years that car was made.

So the pivot table is not what I am looking for because it cannot be read by other programms like Word, because it uses filters etc.