0

![enter image description here][1] In below pic shows actual table data

"Year  Month  Item_Name  Office_Name  Issued Issued_Amount
2014    1     Blank C.D    CEO         2     5.0
2014    1     Blank C.DR   CEO         3     6.0
2014    1     Box File     CEO         4     10.0
2014    1     Strip file   CEO         5     50
2014    1     Blank C.D    TC          4     20.0
2014    1     Blank C.DR   TC          2     50.0
2014    1     Box File     TC          3     10.0
2014    1     Strip file   TC          7     70.0
2014    1     Blank C.D    B_D          4     40.0
2014    1     Blank C.DR   B_D          5     50.0
2014    1     Box File     B_D          6     30.0
2014    1     Strip file   B_D          8     20

And Want to transpose rows into columns data

"Year  Month  Item_Name    Issued_CEO    Issued_TC  Issued_B_D 
2014    1     Blank C.D       2          4         4
2014    1     Blank C.DR      3          2         5 
2014    1     Box File        4          3         6
2014    1     Strip file      5          7         8

Like Below this this MY code But I could Not Get Proper Result

Abhik Chakraborty
  • 44,654
  • 6
  • 52
  • 63

0 Answers0