如果值尚不存在，我如何连接字符串

I have a csv database with loads of colours, what I want is to concatenate all unique colours and separate them by a comma. I need to somehow only include string values once. See example below...I have a csv database with loads of colours, wh