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.
