How do I filter out data with unique values in repeated rows?

helenjin1

Hi, I'm trying to filter out data for points with multiples of the same name but possible different values. There are a lot of repeats but I'm trying to separate out the few that differ.

For example my data looks like this:

Column 1 | Column 2 | Column 3

Name 1    |  AB          |  Cat

Name 1    |  BX          | Dog

Name 2    |  AB          |  Cat

Name 2    |  AB          |  Cat

I want to filter by column 2 based on the names in column 1.

Thableaus

@helenjin1 

That's a strange behaviour.

This combination should remove all duplicates (Column 1 + Column 2 duplicates), and leave your dataset with different values of these two fields.

Could you show a sample of what you're trying to doing and your desired output, please?

Cheers,