Excel Report as Excel Pivot Table as data source

I have to create a report in excel.I have to use a pivot table as datasource.

For example my pivot table is like below.

Year column is dynamic(count may decrease or increase)

Year Category Value
-----------------------------
2009 A 58
2012 A 10
2014 B 9
2013 c 7
2014 C 12
2012 c 54
2013 B 8

In my excel report I have to show like below.


Year A B C
--------------------------
2009 58 0
2012 10 0 54
2013 0 8 7
2014 0 9 12
--------------------------
Total 68 17 73

Please give me a solution for this.


Thank you.
Subbu

Can any one please help me?