merge column with delimited values without splitting

[Larrie_C]

Hey everyone,

I have the folowing data: 

a	100
b	100, 101, 102
c	102,103
d	102

And ID's

100	yellow
101	blue
102	green
103	purple

Is there a way to merge the colors into the first table, without having to delimit them an joining together after merging each column? 

The endresult should look like this:

a	yellow
b	yellow, blue, green
c	green, purple
d	green

Thanks

[camargos88]

@Larrie_C ,

Check the attached file.

Or the previous step has the normalized table:

[Fowmy · Accepted solution]

@Larrie_C 

That is the way to go but after you merge with the color table, then you can use the group function concatenate the colors the first column.

________________________

If my answer was helpful, please consider Accept it as the solution to help the other members find it

Click on the Thumbs-Up icon if you like this reply 🙂

YouTube  LinkedIn