Hi all,
I want to get the unique values in a table considering all values in each row. Let me explain with a simple example:
Considering the table below,
ID | Country | City |
A | EN | London |
B | EN | Leeds |
A | EN | London |
C | EN | Oxford |
D | EN | Cambridge |
B | EN | Leeds |
D | EN | Cambridge |
A | EN | London |
E | EN | Liverpool |
How can I obtain the unique rows? The output should look like the table below,
ID | Country | City |
A | EN | London |
B | EN | Leeds |
C | EN | Oxford |
D | EN | Cambridge |
E | EN | Liverpool |
Cheers!
Solved! Go to Solution.
Many thanks! I initially asked because I thought that I was not using the "Unique" tool properly. I then realised that the mistake was on my inputs.