Breaks in a Table by Value

[#1]

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.

[sivarajs]

its better to use pivot table to remove multiple entries of same value