Summarize data into one field

[Nicolaas_Vercruyse]

Hello,

I have a column looking like this and I would need to make a summary table but adding the data in one field with as / between it.

input file

Adam	Green
George	Red
George	Yellow
Tracy	Red
Adam	Orange
George	Orange

and output would need to look like this:

Adam	Green / Orange
George	Red / Yellow / Orange
Tracy	Red

Thanks in advance for your feedback

Nicolaas

[JosephSerpis · Accepted solution]

Hi @Nicolaas_Vercruyse you can use the concantenate function in the summarise tool to achieve your desired output.

[caltang · Accepted solution]

Like so: