Forum Discussion
Find duplicates
From your original query, then it appears to be the expected output (New table with duplicates):
This can be achieved using duplicate table and then simply using 'Keep Duplicates' (option mentioned in the previous comments by @Fowmy).
If this post solved your query, mark this post as a solution and give a thumbs up !!!
wenners68
In Power Query, you can you the Keep Duplicates option to keep only the duplicated records if you mean that way.
________________________
Did I answer your question? Mark this post as a solution, this will help others!.
Click on the Thumbs-Up icon on the right if you like this reply 🙂
Hi, I only want the duplicates, nothing else.
From your original query, then it appears to be the expected output (New table with duplicates):
This can be achieved using duplicate table and then simply using 'Keep Duplicates' (option mentioned in the previous comments by @Fowmy).
If this post solved your query, mark this post as a solution and give a thumbs up !!!
wenners68
Did you try what I suggested?
You perform the following 2 steps to get only duplicated rows with single line.
If you can show the expected output form your example, it will give clear understanding.________________________
Did I answer your question? Mark this post as a solution, this will help others!.
Click on the Thumbs-Up icon on the right if you like this reply 🙂
