Excel 2013 Power Query 10

UnPivot Feature to Create Proper Data Sets (2 Examples)


See how to:
(00:08) Problem Set up
(00:49) Use Filter Feature rather than Table Feature to get Table into Power Query
(01:30) Unpivot Cross Tabulated Table into Proper Data Set
(03:12) Unpivot Only Two Columns in table to create Proper Data Set.
(04:48) Sort is different than in Excel.


Download “Excel 2013 Power Query Videos 07-13” Excel-2013-Power-Query-Videos-07-13.zip – Downloaded 73 times – 33 MB

Be the first to comment

Leave a Reply