Hi Can you please help me find the Distinct Count ?
Original Data Set is below . Please note there are more columns, I have put till Column5 just for this example
| Load Country | Discharge Country | Column1 | Column2 | Column3 | Column4 | Column5 |
| ALGERIA | QATAR | 1 | 2 | | | |
| ALGERIA | QATAR | 2 | 1 | 1 | 3 | |
| ALGERIA | PERU | 4 | 5 | 6 | 4 | |
| ARGENTINA | PERU | 5 | 5 | 7 | 9 | |
| ARGENTINA | ECUADOR | 2 | 2 | 2 | 7 | |
This is the output that I want, Load Country and Discharge Country should be grouped together see below and I need to find the Distinct Count of the numbers inside the columns
| Load Country | Discharge Country | Column1 | Column2 | Column3 | Column4 | | Distinct Count |
| ALGERIA | QATAR | 1 | 2 | 3 | | | 3 |
| ALGERIA | PERU | 4 | 5 | 6 | | | 3 |
| ARGENTINA | PERU | 5 | 7 | 9 | | | 3 |
| ARGENTINA | ECUADOR | 2 | 7 | | | | 2 |
How can I find the Distinct Count
Thank you
