Removing duplicates

[CDP_Beer]

I have a data set that looks like the following (on the left), all of the values for each category are the same. I want to display it in glide like the table on the right, but when trying to filter for duplicates I can only remove all duplicates (not just show the first one). Any ideas? Thanks!

[MaximeBaker]

Add a row id column in the base table.

Create a new tab in your google sheet, and at A1, enter:
=UNIQUE('Name of your first tab'!A1:B ; false ; false)
It will give you only unique rows.

[Jeff_Hager]

This is a common method using the same table. Then you can just filter the table.

Filter to display DISTINCT (or Unique) rows based on specified columns

I typically use or recommend the following method: Make sure there is a Row ID column. Create a single Relation or Query to link similar rows to themselves based on similar values. Create a Lookup or Single Value column to retrieve the first matching Row ID from the Relation/Query. Finally create an IF column comparing the row’s Row ID to the Lookup/Single Value column and return true if there is a match. Only the first occurrence will be a match.

[CDP_Beer]

Is there any functionality like that in glide? I just copied over what I am trying to do in google sheets for easier visibility

[MaximeBaker]

I mean, you could, but you will have to add every key by hand on the first column, then add a relation column and lookups to the other related columns.

You could use schedule workflow to make a copy of each unique element in another table, but that may not be the best workaround…

[MaximeBaker]

Or use the method above.

[ThinhDinh]

I think you should prioritize using the method Jeff suggests, and move everything you can to Glide Tables.

[Darren_Murphy]

@MaximeBaker

Create a new tab in your google sheet, and at A1, enter:
=UNIQUE('Name of your first tab'!A1:B ; false ; false)
It will give you only unique rows.

We stopped recommending spreadsheet formulas at least 2 or 3 years ago. They are almost never required, except for a very few rare cases

[Atom]

I think I understand what you’re trying to achieve. I recommend downloading your Google Sheet and importing it into glide as a new Glide table.

You data table will look something like this:

And you can create a helper table where each row will automatically be 1 of the categories:

1. First we lookup all the Row IDs:
   

   

2. Then we get the index of the current row:
   

   

3. Then we lookup all the categories from the data table:
   

   

4. Get Unique Elements from the categories:
   

   

5. Then a single value column to retrieve the category based on the row #:
   

   

6: Finally a relation and lookup:

Make sure you have enough rows in the helper tables for the number of categories.

[MaximeBaker]

How would it be possible to automate that from Glide table?

[Darren_Murphy]

See the link that Jeff gave. That’s probably the simplest method.