microsoft is a wonderful office tool for all type of data related operations. Lot of data options are available. For remove a particular column data duplicates use the following method. 1. select the column 2.Press on data tab of microsoft excel 3.Can see a command “remove dupliactes”. Also we can use advanced command in the…