Combining values of rows

[Ayaanarjun-5885]

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 ID	Record ID	Conclusion ID	Output
Apple	ABC	Class	Class vs Object
Apple	XYZ	Object	Class vs Object
Pine apple	PQR	Class	Class vs Subject
Pine apple	GHI	Subject	Class vs Subject
Guava	MNO	Object	Object vs Subject
Guava	EFG	Subject	Object vs Subject

[griffinwelsh]

@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.