how do you combine cells in the same column using the same identifier

[ac1223]

I Basically need to know if there is a way to say "if ID and Sequence are the same, combine the colors into 1 cell". It is ok if it combines the color cells in every row.

 

[dreid1011]

Perhaps this:

Book1
	A	B	C
1	ID	Seq	Color
2	1234	1	Red
3	1234	1	Blue
4	5555	1	Red
5	5555	1	Purple
6	5555	1	Blue
7
8
9
10	1234	1	Red;Blue
11	5555	1	Red;Purple;Blue
Sheet2

Cell Formulas
Range	Formula
C10:C11	C10	=TEXTJOIN(";",,FILTER($C$2:$C$6,($A$2:$A$6=A10)*($B$2:$B$6=B10)))

 

[alansidman]

An alternative with Power Pivot