Delete Duplicate Items In SharePoint List

Question

Migrated from wss 3.0 to sp 2010 I have notice few Lists have been Duplicated twice as shown Below Example of

Name     Application   Data    Completed
Test1     Sp2010       March     NO
Test2     Wss3.0       July      Yes
Test2     Wss3.0       July      Yes-------> Should remove this and Below Table 
Test3     Moss2007     June      Yes
Test4     None         Jan       NO
Test4     None         Jan       NO

Name     Application   Data    Completed
Test1     Sp2010       March     NO
Test2     Wss3.0       July      Yes
Test2     Wss3.0       July      Yes
Test3     Moss2007     June      Yes
Test4     None         Jan       NO
Test4     None         Jan       NO

if any scripts that would be great!!!

Answer 1

Deleting duplicated items within list have already been answered in our forum

You might have to change few references before running the actual PowerShell script

Answer 2

Duplicate records are pain, no matter how careful we are but over a period of time there is a good chance that duplicate records got entered/imported in sharepoint lists. It is better to remove or merge duplicate from your sharepoint list periodically to keep your data clean and valuable. Out of the box there is not an easy way to do it. With this add-in now you can do it fast and free of cost. Try the add-in, if any issues contact for free support. Check this https://store.office.com/en-us/app.aspx?assetid=WA104381013&sourcecorrid=adc96e23-f032-4606-85ff-0f70cc2f0657&searchapppos=0&ui=en-US&rs=en-US&ad=US&appredirect=false