Macro to Turn Pivoted Data Back Into A Table

Good morning all.

I wanted to ask if anybody had some code they could suggest to help me move some data around on an excel sheet.
I have a table of info that is similar to a pivot table but is just a normal table of data, however I need to shift it around back to a list of data so i can use a pivot table to manipulate the data.

I have pasted an example of what i need if any body could help it would be very much appreciated.

Thanks
Matt