You should be able to accomplish what you want by using a pivot table.

- Highlight your table/data set and insert a pivot table
- Drag ID1 field into the Row Labels box
- Drag your Color fields into the Values box
- For each field you have in the Values box, change the Value Field Settings to Summarize values by Max and not Sum.

You can either keep the pivot table or copy/paste special values.