How to concatenate

Question

if one contact has multiple products how to concatenate in alteryx. Please help me build a workflow

for example:

ContactProductContact 1AppleContact 2AppleContact 1OrangeContact 3AppleContact 1KiwiContact 3KiwiContact 4Apple

Desired Output:

ContactAll ProductsContact 1Apple, Orange KiwiContact 2AppleContact 3Apple, KiwiContact 4Apple

dreldrel · Answer

Just a small thing to add on - in the summarise tool, you can specify the delimiter at the bottom of the config window

aatalai · Answer

agree with @JosephSerpis but might add a sort after the summarise to have the data in order

alexnajm · Answer

100% agreed with @JosephSerpis ^