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

	Col-Z	Col-Y	Col-X
Row-A	RR	RR	RR
Row-B	QQ	QQ	QQ
Row-C	PP	PP	PP

<colgroup><col><col span="3"></colgroup><tbody>
</tbody>

To Below Table

Row-A	Col-Z	RR
Row-A	Col-Y	RR
Row-A	Col-X	RR
Row-B	Col-Z	QQ
Row-B	Col-Y	QQ
Row-B	Col-X	QQ
Row-C	Col-Z	PP
Row-C	Col-Y	PP
Row-C	Col-X	PP

<colgroup><col width="64" span="3" style="width:48pt"> </colgroup><tbody>
</tbody>

Thanks & Regards,
Raghukanth

 

[RoryA]

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