Keep all the duplicate tables in the table

Question

Hi everyone!

I have a table that looks like this:

Item CodePlantItem Min QtyItem Max Qty5060100.02.11.00001A125060100.07.11.00002B125060100.07.11.00002C13

If I use the unique tools, the last two rows will be splitted , one will go in the Uniques and the other in the Duplicates.
How can I create a table with all the items that that appear 2 or more times in my input table?
The result in this example should be like this:

Item CodePlantItem Min QtyItem Max Qty5060100.07.11.00002B125060100.07.11.00002C13

Thank you in advance!

LukeM · Accepted Answer

Hi @PNiccolo

Download the Crew Macro pack as there is a tool in their called Only Unique. This splits data to having only the uniques out the 'U' and all the duplicated rows in the 'D'.

Luke

DiganP · Accepted Answer

@PNiccolo Attached is the workflow that does the trick! Let me know if this works for you!