How to get all duplicates in 1 list

[soncoku]

Hey everyone.

I have this long list of name where I have duplicates (sometimes even 9 repetitions of the same name).

If I use the duplicate tool it does give me the duplicates but it keeps one in the list of the Unique results.

For example:

1. England

2. Spain

3. England

4. England

5. England

The Unique tool would give me this result :
Unique: Englad, Spain
Duplicate: England, England, England

What I want to achieve is to have all records that are repeated in 1 list.

Like this:

Unique: Spain
Duplicate: England, England, England, England

Any ideas?

[soncoku]

@Emil_Kos  The solution I was looking for. 
Thank you 🙂

[atcodedog05]

Hi @soncoku 

My take on this

Output 1:

Output 2:

Hope this helps 🙂

[soncoku]

@TheOC  thank you very much for the time and effort. @Emil_Kos solved it

[grazitti_sapna · Accepted solution]

@soncoku , I thought you were looking something for solution like you mentioned in your post anyways I have an easier approach if it helps.

Thanks.

[TheOC]

hey @soncoku 
Not a problem, glad you could find a solution!

[soncoku]

@grazitti_sapna This would work perfectly as well 😄 Thank you.

[soncoku]

@TheOC 

@grazitti_sapna 

@atcodedog05 

@Emil_Kos 

@JosephSerpis 

I want to thank you all for taking the time and effort to help me with my problem. You're the best 🙂 .
Alteryx, in my opinion has one of the best community support groups 🙂

[grazitti_sapna]

@soncoku , Welcome. We are always happy to help you and others facing challenges while solving their problems 🙂

[TheOC]

@soncoku 

You are more than welcome! The Alteryx community is fantastic! If you ever need anything else feel free to make another post or my inbox is always open!

Have a great weekend!

[acaryasin01]

Thanks @grazitti_sapna  I think, you found best and easy solution...