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!
Have you tried the summarize tool? Group By Serial Number and concatenate by References
thanks @alexnajm
Happy to help!
