concatenate in alteryx

[griseldagomes]

Hi Experts, Looking to concatenate the values at a serial number level so as to compile all relevant unique ref's in one cell. Can you please help how can I achieve this. Input and desired output is attached for easy reference. Thanks!

[alexnajm · Accepted solution]

Have you tried the summarize tool? Group By Serial Number and concatenate by References

[griseldagomes]

thanks @alexnajm 

[alexnajm]

Happy to help!