Convert Pivot Table Format to Normal Format

[mapleaes]

Hi,
Is it possible to convert pivot table data into a normal format?
I was told to compare two worksheet, one is in normal format while another is an un-edit-able, pivot table format

And I need the pivot table format restored to normal format to be able to do anything.
While I understand it is possible to manually restore the worksheet, I need an automated way (Or at least a more easier/quicker way than editing the whole sheet) to complete this task as there is a lot of worksheet i need to restore.

In my searches for a solution, I came across this thread:
http://www.excelforum.com/excel-gene...ar-format.html
Which had a similar problem as mine, but the problem is, I dont kinda understand the solution posted

Can anyone suggest a new solution to me or atleast explain the solution in the thread mentioned above?

I have attached the worksheet in pivot table format in this thread, along with the restored format inside.

Any help is much appreciated, thank you very much