Hello,
I have data that looks like the following table. Note I've sorted the table by each column and the last column 'Number' in ascending order because I only want to keep that first number for every row where the year/month/country are the same. Basically like removing duplicates (excluding the Number column) and keeping the first row of each instance.
| Year | Month | Country | Number |
| 2021 | MAY | USA | 80 |
| 2021 | MAY | USA | 81 |
| 2022 | FEB | ITALY | 30 |
| 2022 | FEB | ITALY | 35 |
| 2022 | DEC | GERMANY | 115 |
So I want the output to look like this:
| Year | Month | Country | Number |
| 2021 | MAY | USA | 80 |
| 2022 | FEB | ITALY | 30 |
| 2022 | DEC | GERMANY | 115 |
any ideas please? I'm stuck after the sorting.
Any help is much appreciated!