Cleaning up data getting unique list

[V-GEe7]

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

[ShankerV · Accepted 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

[cjaneczko]

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. 

[usmanbashir]

@V-GEe7  - please see attached workflow. Hope this helps!

[V-GEe7]

Thank you all for a quick response. 

Really appreciate it

V