Concatenating values in Same cell in Alteryx

[Karthick461]

Hi,

 I have a data like below . Line 2 and Line 3 is same for ( Plant, Material, Week ) . Only difference is Equipment.

I need to group the equipment number in same cell like AQ,G1 for Line 2. , so that we can ignore Line 3

like this below

For Line 1 and Line 4, no need of ,(comma) at the end

anyway to achieve this

[Luke_C]

Hi @Karthick461 

You can use the summarize tool:

[messi007 · Accepted solution]

@Karthick461,

Please see below :

Attached the workflow,

Regards,