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.
DESCRIPTION See how to use Power Query (Get & Transform) with Input Variables from Excel Sheet to Extract Records and create a Revenue Report. Here are the steps: (00:15) Introduction including Preview of Finished Solution [Read More >>>]
DESCRIPTION In this video learn how to rearrange a product code using Excel Spreadsheet Functions and Power Query Functions. Also see that Flash Fill does not seem to work. Learn the Power Query equivalent for [Read More >>>]
DESCRIPTION See an example of how to invoke Query Dependencies View in Power Query (Get & Transform) WORKBOOKS
EXCEL is a registered trademark of the Microsoft Corporation. MasterExcel is not sponsored by nor affiliated in any way with the Microsoft Corporation.
Leave a Reply
You must be logged in to post a comment.