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.
Solved! Go to Solution.
You just need a cross tab tool for this.
Thanks @Christina_H That worked great for me...Actually I was trying to use the Cross Tab and Transpose but tools setting for Cross tab were incorrect.
Thanks again for your help🙂