Description of Example

We have a simple table of population for each city. It can be noticed that there are duplicate data for the city of London in this table. The objective is to remove these duplicated entries and keep only one row of data. The desired result are highlighted in blue box in below figure.

How is it done

Step 1. Select the table
Step 2. Go to Data > Remove Duplicates

Step 3. A small window will come out as shown below. Select the columns by which duplicates will be checked, then press 'OK'.
See below figure.

Step 4. A confirmation message will pop out like as shown below. Press 'OK' and viola, you will now have a free-duplicate data.

These steps are summarized in the following screen recording.