Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Please advise on the following problem.
I have data like this. I am using Straight Table.
Contry | State | Revenue |
---|---|---|
USA | New York | 2 |
USA | New York | 3 |
USA | New Jersey | 4 |
MEXICO | State1 | 5 |
MEXICO | State2 | 6 |
However, I want the data like this. How can I remove the dupes in the first column ?
Contry | State | Revenue |
---|---|---|
USA | New York | 2 |
New York | 3 | |
New Jersey | 4 | |
MEXICO | State1 | 5 |
State2 | 6 |
-Regards.
its better to use pivot table to remove multiple entries of same value