I have a table with the following sampled data:

```
Name    Color

Alice   Green
Bob     Black
Chris   Green
Chris   Black     
David   Red
Peter   Blue
Simon   Blue
Simon   Red
Simon   Green

```

Ultimately, I want to reduce the table by consolidating the Color column like:

```
Name    Color

Alice   Green
Bob     Black
Chris   Green, Black
David   Red
Peter   Blue
Simon   Blue, Red, Green

```

such that Name can become unique.

The table has no PRIMARY KEY, I got as far as creating a new column using ROW\_NUMBER to distinguishing duplicates but don't know what to do next.:

```
rownumber    Name    Color

1            Alice   Green
1            Bob     Black
1            Chris   Green
2            Chris   Black     
1            David   Red
1            Peter   Blue
1            Simon   Blue
2            Simon   Red
3            Simon   Green

```