Pivot table data into excel sheet dynamically

[subrahmanyam85]

Hi,

I have a pivot table like below.

[TABLE="width: 411"]
<tbody>[TR]
[TD]Year
[/TD]
[TD]Ryear
[/TD]
[TD]Version
[/TD]
[TD]Category
[/TD]
[TD]Product
[/TD]
[TD]Value
[/TD]
[/TR]
[TR]
[TD="align: right"]2011
[/TD]
[TD="align: right"]2011
[/TD]
[TD]GL
[/TD]
[TD]Cat A
[/TD]
[TD]P1
[/TD]
[TD="align: right"]205
[/TD]
[/TR]
[TR]
[TD="align: right"]2011
[/TD]
[TD="align: right"]2013
[/TD]
[TD]K
[/TD]
[TD]Cat B
[/TD]
[TD]P2
[/TD]
[TD="align: right"]202.3
[/TD]
[/TR]
[TR]
[TD="align: right"]2008
[/TD]
[TD="align: right"]2013
[/TD]
[TD]T
[/TD]
[TD]Cat B
[/TD]
[TD]P3
[/TD]
[TD="align: right"]110.5
[/TD]
[/TR]
[TR]
[TD="align: right"]2004
[/TD]
[TD="align: right"]2011
[/TD]
[TD]GL
[/TD]
[TD]Cat A
[/TD]
[TD]P4
[/TD]
[TD="align: right"]45
[/TD]
[/TR]
[TR]
[TD="align: right"]2008
[/TD]
[TD="align: right"]2011
[/TD]
[TD]K
[/TD]
[TD]Cat C
[/TD]
[TD]P5
[/TD]
[TD="align: right"]89
[/TD]
[/TR]
</tbody>[/TABLE]

Here products are fixed P1 to P5 remaining all column values are not fixed.
Year starts minimum 1993 and Max year is current year.
I have to show the data like below.(Pivot table increasing dynamically)
[TABLE="width: 603"]
<tbody>[TR]
[TD]Year
[/TD]
[TD]Ryear
[/TD]
[TD]Version
[/TD]
[TD]Category
[/TD]
[TD]P1
[/TD]
[TD]P2
[/TD]
[TD]P3
[/TD]
[TD]P4
[/TD]
[TD]P5
[/TD]
[/TR]
[TR]
[TD="align: right"]2004
[/TD]
[TD="align: right"]2011
[/TD]
[TD]GL
[/TD]
[TD]Cat A
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]45
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]2008
[/TD]
[TD="align: right"]2011
[/TD]
[TD]K
[/TD]
[TD]Cat B
[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]89
[/TD]
[/TR]
[TR]
[TD="align: right"]2008
[/TD]
[TD="align: right"]2013
[/TD]
[TD]T
[/TD]
[TD]Cat C
[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]110.5
[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[/TR]
[TR]
[TD="align: right"]2011
[/TD]
[TD="align: right"]2011
[/TD]
[TD]GL
[/TD]
[TD]Cat A
[/TD]
[TD="align: right"]205
[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[/TR]
[TR]
[TD="align: right"]2011
[/TD]
[TD="align: right"]2013
[/TD]
[TD]K
[/TD]
[TD]Cat B
[/TD]
[TD][/TD]
[TD="align: right"]202.3
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]


Can you please let me know how to achieve this?

I am hitting my head against my monitor...

 

[cyrilbrd]

Hi,
how are P1 to P5 fields arranged in your raw data?
what do you mean by dynamically? do you want the pivot to refresh without having to call refresh? or do you want the range to consider new rows? thanks to clarify.