Hi Experts,
Need help on this trying to find a solution. Please help
This is just a dummy data picked randomly.
Input:
| Country | City | Person | Age | Income |
| India | Delhi | Ram | 28 | 1000 |
| India | Delhi | Sita | 27 | 900 |
| India | Delhi | Mohan | 29 | 980 |
| India | Mumbai | Mohit | 30 | 950 |
| India | Mumbai | Misha | 7 | 0 |
| Australia | Sydney | Mark | 20 | 200 |
| Australia | Sydney | John | 18 | 150 |
| Australia | Perth | Micheal | 45 | 5000 |
| Australia | Perth | Eric | 38 | 2500 |
| Australia | Perth | Colette | 15 | 350 |
| Australia | Melbourne | Isable | 21 | 600 |
| US | New York | Mark | 26 | 750 |
| US | Washington | Jack | 29 | 800 |
| US | Washington | Mike | 24 | 500 |
| US | Seattle | Simon | 36 | 3500 |
| US | Seattle | Jack | 41 | 4700 |
| US | Chicago | Kelvin | 27 | 550 |
| US | Chicago | Imran | 33 | 1100 |
| US | Chicago | Andy | 55 | 650 |
Desired Output:
| Country/City | Person | Age | Income |
| India | | | |
| Delhi | Ram | 28 | 1000 |
| Delhi | Sita | 27 | 900 |
| Delhi | Mohan | 29 | 980 |
| Mumbai | Mohit | 30 | 950 |
| Mumbai | Misha | 7 | 0 |
| Australia | | | |
| Sydney | Mark | 20 | 200 |
| Sydney | John | 18 | 150 |
| Perth | Micheal | 45 | 5000 |
| Perth | Eric | 38 | 2500 |
| Perth | Colette | 15 | 350 |
| Melbourne | Isable | 21 | 600 |
| US | | | |
| New York | Mark | 26 | 750 |
| Washington | Jack | 29 | 800 |
| Washington | Mike | 24 | 500 |
| Seattle | Simon | 36 | 3500 |
| Seattle | Jack | 41 | 4700 |
| Chicago | Kelvin | 27 | 550 |
| Chicago | Imran | 33 | 1100 |
| Chicago | Andy | 55 | 650 |
