How to merge data together and combine data?

Katieemj

New Member
Joined
Jan 30, 2018
Messages
2
MakeModelCC CountryYear IDModel IDSKUYear
Adly300 Crusader Quad 300Europen/an/a7120962005
Adly300 Crusader Quad 300Europen/an/a7120962006
Adly300 Crusader Quad 300Europen/an/a7120962007
Adly300 Crusader Quad300Europen/an/a7190022005
Adly300 Crusader Quad300Europen/an/a7190022006
Adly300 Crusader Quad300Europen/an/a7190022007
Adly300 Crusader Quad300Europen/an/a8130902005
Adly300 Crusader Quad300Europen/an/a8130902006
Adly300 Crusader Quad300Europen/an/a8130902007
Adly300 Crusader Quad 300 Europen/an/a712096 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>
 

Excel Facts

What is the last column in Excel?
Excel columns run from A to Z, AA to AZ, AAA to XFD. The last column is XFD.

Katieemj

New Member
Joined
Jan 30, 2018
Messages
2
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
 

Forum statistics

Threads
1,144,374
Messages
5,723,992
Members
422,529
Latest member
mbilal429

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top