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

hurry85

New Member
Joined
Mar 21, 2019
Messages
1
[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]
 

Some videos you may like

Excel Facts

Round to nearest half hour?
Use =MROUND(A2,"0:30") to round to nearest half hour. Use =CEILING(A2,"0:30") to round to next half hour.

=ODIN=

Active Member
Joined
Dec 3, 2009
Messages
288
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>
 

Watch MrExcel Video

Forum statistics

Threads
1,108,507
Messages
5,523,308
Members
409,509
Latest member
CheekyDevil2386

This Week's Hot Topics

Top