Combining values of rows

Question

Hi, I have below data and I wanted to combine the values of "Conclusion ID" row according to the cluster as shown below. How Can I do it. I have provided desired output as well

Cluster IDRecord IDConclusion IDOutput AppleABCClassClass vs ObjectAppleXYZObjectClass vs ObjectPine applePQRClassClass vs SubjectPine appleGHISubjectClass vs SubjectGuavaMNOObjectObject vs SubjectGuavaEFGSubjectObject vs Subject

griffinwelsh · Answer

@Ayaanarjun-5885  see the steps below and attached solution

1. Use a summarize tool. Group by Cluster ID concatenate Conclusion ID. Use a separator of " VS "

2. Join the summarize tool output with the data set on cluster id.

Solution.yxmd