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?

[JosephSerpis]

Hi @soncoku I mocked up a workflow that showcases how to do that. Let me know what you think?

[Emil_Kos · Accepted solution]

Hi @soncoku,

probably not most efficient solution but it works. 

[atcodedog05]

_

[TheOC]

Hi @soncoku ,

I managed this with two summerize tools, please find attached my workflow of how this was done:

I ran with this input:

and ended with an output as you asked:

Let me know if i can help any further!

[grazitti_sapna]

Hi @soncoku , give this a try.

Thanks.

[soncoku]

@atcodedog05  I use the Unique tool everyday but it doesn't help me with this situation 😕

[atcodedog05]

@soncoku  Sorry my bad didnt read completely. My approach would be similar to @TheOC 

My system is having issue. Guess got to fix that😶

[soncoku]

@TheOC good one but you concatenate everything in one cell.

I reality I have a list with +1000 rows with at 47 cols, that doesn't make my job easier 😛

[TheOC]

oh, i can adjust that no problem! How would you like it to output specifically?