NorthStar Analytics

HiDocs High-Quality Ghost Documentation Theme

How to remove duplicates in Google Sheets?

How to remove duplicates in Google Sheets?

Duplicate entries or duplicate rows happen when your data appears more than once. They must be found and removed before any data analysis is performed.

Imagine you have two instances of the same customer transaction in your database. When you summarize your data, you will make decisions based on inaccurate data. Fixing them in Google Spreadsheets does not require much time. In this guide, we'll see how to remove duplicates in Google Sheets.

How to remove duplicates using the menu?

Use the menu to remove duplicates:

  1. Select the relevant column
  2. Menu-> Data -> Data clean-up -> Remove duplicates

From the screen that comes up, you have to make sure to select the title. The header will be included unless you specify that. With 'Expand' you can expand your selection for other columns.

Since I have two columns here, columns A and B are shown. If I had more columns, they would be shown, as well. 5 columns, for instance, would be shown A: F.

Before going to the menu, you need to select the column. If you go to the menu without making a selection, you will encounter a warning:

Just as we can select an entire column, we can do the same by choosing a specific range of cells.

As you can see, column B is not affected at all when we operate on column A.

When we select two columns at the same time and go to the menu, 'remove duplicates' will not be visible. If you want to operate for two columns,

  1. Select single column->go to menu
  2. Select Remove duplicates
  3. You can duplicate the column selection from the menu that comes up.

How to remove duplicates using the help menu?

We can remove duplicates using the menu, as well as using the help menu.

  1. Select relevant column
  2. Menu->Data -> Help
  3. Write->Remove duplicates

How to remove duplicates using the UNIQUE function?

Now, let's use a function to do what we did using the menu.

  1. Come to the column you want to print the new column
  2. =UNIQUE (cell range)

You can find detailed information about the function here->"How to use the UNIQUE function in Google Sheets?"

What to do if there is a space at the beginning of the data?

If your data starts with a space, it does not include repeaters. You need to remove the spaces first using the menu and function.

How to remove spaces using the menu?

Let's see how to decode the data using the menu in the header with spaces:

Menu -> Data -> Data clean-up -> Trim whitespace

How to remove spaces using the TRIM function?

You can also do the operation using the menu with the function.

  1. Go to the column you want to remove spaces
  2. =TRIM(cell range)

The spaces at the head of the cell have been removed. Now we can handle duplicates.

You can also find more information about duplicates at "How to highlight duplicates in Google Sheets"

Make your business data transparent!
  • Subscribe to a package

    Subscribe and explore the limits of your business with data or thinking to expand your agency value proposition with Google Data Studio dashboards?

  • Request unlimited dashboards

    You can request as many dashbaords you might have and as many revisions as you might need. We create a queue of your tasks, the first tasks that come in are the tasks that we’ll deliver first.

  • Your Data Studio Department

    Optimise your business with complete transparency through dashboards or provide value-added Google Data Studio service to your agency clients.

Make your business transparent

The fastest easy-to-use Google Data Studio dashboards without any recurring cost.