Want to Pivot in Script....

[nasirsaikh]

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

[dplr-rn]

You need generic load

The Generic Load