Pivot Table data to be copied to new sheet

[rajeshdurga]

Hi,

I want to copy the pivot table data to a new work sheet along with values and formats and the new sheet should be a normal sheet.Later ones copied the pivot data to new sheet,the original pivot sheet needs to be deleted.
I have tried many options but empty data is observing in the new sheet .Anyone help

 

[rajeshdurga]

Can someone help ?