I need to be able to combine several cells into on cell as a comma
separated list based on a criterion in another cell. For example:

A B
1 Part Color
2 123 Green
3 234 Red
4 222 Red
5 9874 Blue

On another sheet I like to have:

A B
1 Color Parts
2 Green 123
3 Red 234,222
4 Blue 9874

Is this possible?

Brian