Dear All,
I have columns contaiting some ageing bucket which i want to do transpose in script....
| Name | Ageing |
| Agent | 8_>=365 Days |
| Agent 1 | 7_271-365 Days |
| Agent 1 | 6_181-270 Days |
| Agent 1 | 5_91-180 Days |
| Agent 1 | 4_61-90 Days |
| Agent 1 | 2_0-30 Days |
| Agent 1 | 3_31-60 Days |
| Agent 1 | 1_Less Than 0 |
| |
want to change like below through script....
| Row Labels | 1_Less Than 0 | 2_0-30 Days | 3_31-60 Days | 4_61-90 Days | 5_91-180 Days | 6_181-270 Days | 7_271-365 Days | 8_>=365 Days | Grand Total |
| Agent | | |
| Agent 1 | | |
| Grand Total | | |
