In the data set below, how can I count only the first occurrence of color over the Sequence (string dimension).

For example, although through each sequence color Red for ID 1 changes to Blue I should count this as Red (whatever value the first occurrence has)

Below is how the final counts should look like:

I am attaching a starter workbook.

Thank you for your help!