Combine Unique Values

[JingYih_Herbalife]

I have set of data with multiple vendors. There are instances where 1 vendor may provide multiple type of services and each type of service is shown in a separate line. There are instances where 1 vendor only provides 1 type of service only. I would like to combine the type of services into 1 line. What tools do I use to achieve this result? 

I include the original data and the required result in attached. 

Appreciate the guidance. 

[messi007]

@JingYih_Herbalife,

You can use summarize tool with concatenate function :

Attached the workflow,

Hope this helps!

Regards,