How to merge data together and combine data?

[Katieemj]

Make	Model		CC	Country	Year ID	Model ID	SKU	Year
Adly	300 Crusader Quad		300	Europe	n/a	n/a	712096	2005
Adly	300 Crusader Quad		300	Europe	n/a	n/a	712096	2006
Adly	300 Crusader Quad		300	Europe	n/a	n/a	712096	2007
Adly	300 Crusader Quad		300	Europe	n/a	n/a	719002	2005
Adly	300 Crusader Quad		300	Europe	n/a	n/a	719002	2006
Adly	300 Crusader Quad		300	Europe	n/a	n/a	719002	2007
Adly	300 Crusader Quad		300	Europe	n/a	n/a	813090	2005
Adly	300 Crusader Quad		300	Europe	n/a	n/a	813090	2006
Adly	300 Crusader Quad		300	Europe	n/a	n/a	813090	2007
Adly	300 Crusader Quad		300	Europe	n/a	n/a	712096	2005-2007

<colgroup><col width="64" style="width: 48pt;"> <col width="316" style="width: 237pt; mso-width-source: userset; mso-width-alt: 11556;"> <col width="64" style="width: 48pt;" span="5"> <col width="127" style="width: 95pt; mso-width-source: userset; mso-width-alt: 4644;"> <col width="246" style="width: 185pt; mso-width-source: userset; mso-width-alt: 8996;"> <tbody> </tbody>

 

[Katieemj]

Does anybody know a formula so if the data is the same (for example in yellow) it merges it together and combines the dates? (So it looks like the bottom yellow box)
Thanks