How to convert Pivot table structure (values) into actual Pivot, or data tab ready for pivot

[hurry85]

[FONT=&quot]Hi![/FONT]
[FONT=&quot]
[/FONT]
[FONT=&quot]I have a data source that is giving me data as values that is organized like a pivot table (with both rows and columns... if it was just rows it would be an easy task).[/FONT]
[FONT=&quot]
[/FONT]
[FONT=&quot]Is there a way I can turn this into a pivot table (not values) so I could play around with the fields? If I could turn this into a standard data source that would be helpful. Including below a screenshot which shows what i'm dealing with.[/FONT]
[FONT=&quot]
[/FONT]
[FONT=&quot]Here is an example of what my data source is like (just way bigger than this example):

[/FONT]
[FONT=&quot]https://drive.google.com/open?id=10YseEeOmsRZAatLatTDY4qyUInFoMWwp[/FONT]
[FONT=&quot]
[/FONT]
[FONT=&quot]Here is an example of converting the table manually into a simple data table. I basically need to find a way to do this on mass scale and not manually:[/FONT]
[FONT=&quot]https://drive.google.com/open?id=1dt1XJ4RQ_AcO9IKAW9HFXqEsnZkCoCvF[/FONT]
[FONT=&quot]
[/FONT]
[FONT=&quot]Here is an example of actual pivot using the data I manually updated:[/FONT]
[FONT=&quot]https://drive.google.com/open?id=16w_I7dWwt5yTHRdSXCk3me7Gi0AoAtr4[/FONT]
[FONT=&quot]
[/FONT]
[FONT=&quot]
[/FONT]
[FONT=&quot]Anyone that could help?[/FONT]
[FONT=&quot]
[/FONT]
[FONT=&quot]Thanks[/FONT]

 

[=ODIN=]

I use the Nutilities Addin for this. It's free and available here: iwishexcel.com


Once installed, if you hit CTRL+SHIFT+ALT+ENTER in excel, a popup will have a list of tabs showing directions for all utilities. The one you're after is called "unpivot" on the "author's favorites" tab. See Pic below.
<a href="http://www.freeimagehosting.net/commercial-photography/"><img src="https://i.imgur.com/SEQRyX9.jpg" alt="Commercial Photography"></a>