I have a column of data among many with each record displaying information as below, (serial number is not part of the data)
1. Apple,Orange,Apple,Orange
2. Apple,Apple,OrangeOrange,Grapes
3.Grapes,Grapes,Grapes,Grapes
I would like it to display only the unique values as below (serial # is for reference only)
1. Apple,Orange
2. Apple,Orange.Grapes
3. Grapes
What is the quickest and most efficient way to do this?
Thanks,
V
Solved! Go to Solution.
Hi @V-GEe7
One way of doing this.
1. Record ID tool
2. Text to Columns
3. Unique tool
4. Summarize tool
Step 1:
Step 2:
Step 3:
Step 4:
Many thanks
Shanker V
This is one way. Use a Text To Columns and configure it to split to rows. Then use the Unique tool to find unique values, then use the Summarize to group on Record ID and Concatenate the field. Add a sort tool after it by Record ID if you want it back in the original order.
@V-GEe7 - please see attached workflow. Hope this helps!
Thank you all for a quick response.
Really appreciate it
V