Remove (almost) dupplicates

[Julie-Anne97]

Hello all,

I would like to create a slice with multiple criterias and remove duplicates.

My google sheet contains certain rows which are duplicates except for one column where the value is different. In the context of my automation, the contents of that column don't matter however it's important that the user only sees one row instead of all the duplicates.

In the past I have used VLookup or Maxifs to only keep one row however this was with multiple tables and on a google sheet. Here's an example to the data I would like my slice to show : https://docs.google.com/spreadsheets/d/1zbpk0DLbDUypbXACBtJL9m7B6WFOLZFF2M1uYGkZmsM/edit?usp=sharing

I would be very thankful for any advice, thanks

[Suvrutt_Gurjar]

I think you could try with a slice filter expression of 

IN([Name], UNIQUE(Table Name[Name]))

to remove duplicates.

[Steve]

See my response here:

Re: Slice with unique records - Google Cloud Community