Pivot Table view to Normal Table view

[sarsukanth]

Hi All,

I got a different issue, that is there is a data in the pivot table view (not pivot table, its a normal data), we need to get that data as a normal table. Is there any easy way. For better understand I have given below example tables.
Thank you in advance for your support.


From Below Table

[TABLE="width: 260"]
<colgroup><col><col span="3"></colgroup><tbody>[TR]
[TD] [/TD]
[TD]Col-Z[/TD]
[TD]Col-Y[/TD]
[TD]Col-X[/TD]
[/TR]
[TR]
[TD]Row-A[/TD]
[TD]RR[/TD]
[TD]RR[/TD]
[TD]RR[/TD]
[/TR]
[TR]
[TD]Row-B[/TD]
[TD]QQ[/TD]
[TD]QQ[/TD]
[TD]QQ[/TD]
[/TR]
[TR]
[TD]Row-C[/TD]
[TD]PP[/TD]
[TD]PP[/TD]
[TD]PP[/TD]
[/TR]
</tbody>[/TABLE]


To Below Table

[TABLE="width: 192"]
<colgroup><col width="64" span="3" style="width:48pt"> </colgroup><tbody>[TR]
[TD="class: xl65, width: 64"]Row-A[/TD]
[TD="class: xl65, width: 64"]Col-Z[/TD]
[TD="class: xl65, width: 64"]RR[/TD]
[/TR]
[TR]
[TD="class: xl65"]Row-A[/TD]
[TD="class: xl65"]Col-Y[/TD]
[TD="class: xl65"]RR[/TD]
[/TR]
[TR]
[TD="class: xl65"]Row-A[/TD]
[TD="class: xl65"]Col-X[/TD]
[TD="class: xl65"]RR[/TD]
[/TR]
[TR]
[TD="class: xl65"]Row-B[/TD]
[TD="class: xl65"]Col-Z[/TD]
[TD="class: xl65"]QQ[/TD]
[/TR]
[TR]
[TD="class: xl65"]Row-B[/TD]
[TD="class: xl65"]Col-Y[/TD]
[TD="class: xl65"]QQ[/TD]
[/TR]
[TR]
[TD="class: xl65"]Row-B[/TD]
[TD="class: xl65"]Col-X[/TD]
[TD="class: xl65"]QQ[/TD]
[/TR]
[TR]
[TD="class: xl65"]Row-C[/TD]
[TD="class: xl65"]Col-Z[/TD]
[TD="class: xl65"]PP[/TD]
[/TR]
[TR]
[TD="class: xl65"]Row-C[/TD]
[TD="class: xl65"]Col-Y[/TD]
[TD="class: xl65"]PP[/TD]
[/TR]
[TR]
[TD="class: xl65"]Row-C[/TD]
[TD="class: xl65"]Col-X[/TD]
[TD="class: xl65"]PP[/TD]
[/TR]
</tbody>[/TABLE]



Thanks & Regards,
Raghukanth

 

[RoryA]

You can actually use a consolidated range pivot table for this - see Debra's page here.