Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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 |
You need generic load