Excel Magic Trick 1034: Convert Summarized Table To Proper Data Set With PivotTable Trick

Convert Table With Row & Column Criteria To A Proper Data Set With PivotTable Multiple Consolidates Ranges
Convert Summarized Table Into Original Data Set With PivotTable Multiple Consolidates Ranges:

[pietermarais]

Can't tell you how much time this has just saved me - THANK YOU

[SWFan]

This tip saved me quite a bit of time converting Excel reports someone else created into true tabular data. Thanks.

[ChrisLuigiTails]

"URL" is in your URL.
Thanks Vsauce

[manwithgoggles]

Thanks, this is exactly what I needed. Saved me a lot of time and trouble.

[asriansyahds]

Thank you Very much for your video, you just saved me

[mschoenthal]

do you know how to do this with the latest version of Excel for Mac? The wizard has been removed.

[shiryu]

Hi mike, you need an entry presentation for your vids...I guess

[GalgalRezerbi]

Man, this video has "URL" in his url