AnsweredAssumed Answered

Repeat values to single comma delimited field

Question asked by ChrisDeal5711 on Jan 14, 2016
Latest reply on Jan 24, 2016 by Adam Arrowsmith

I'm trying to map the following.  I feel like it should be pretty straightforward, but I'm just not getting it.  Any ideas?

 

Internal ID,Refinement Color
132265,Brown
132265,Gold
132265,Gray
132265,Green
1234,Black
1234,Green

 

to

 

Internal ID,Refinement Color
132265,"Brown,Gold,Gray,Green"
1234,"Black,Green"

Outcomes