Hi All,
My input looks something as below:
| EMPID | Description | Type | Total Amount |
| 1111 | RELOCATION ALLOWANCE | Allowance | 19560 |
| 2222 | RELOCATION ALLOWANCE | Allowance | 18056 |
| 3333 | INTERNET ALLOWANCE | Allowance | 21794 |
| 4444 | INTERNET ALLOWANCE | Allowance | 75935 |
| 5555 | INTERNET ALLOWANCE | Allowance | 40587 |
| 6666 | RELOCATION ALLOWANCE | Allowance | 22922 |
Required OUTPUT:
| EMPID | RELOCATION ALLOWANCE | INTERNET ALLOWANCE | Type |
| 1111 | 19560 | | Allowance |
| 2222 | 18056 | | Allowance |
| 3333 | | 21794 | Allowance |
| 4444 | | 75935 | Allowance |
| 5555 | | 40587 | Allowance |
| 6666 | 22922 | | Allowance |
Appreciate any help on this. Thanks in advance.
