Hello Prince, For more information try the free trial of data match software. http://www.dataladder.com/Download.htm Thanks
If you have Microsoft Access just read the help file. Deduplicating a database is part of the product. You don't to purchase anything new, just run an update query to copy unique rows to a new table. This will also work in Microsoft Excel if you want to manipulate the data table in a spreadsheet. Please tell us more about what you are trying to do, give an example, and I'm sure you'll get more specific feedback and advice. Thanks!