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 Get the Total for each employee when the Employee Name column has many empty cells and the “TOTAL” is in a row without an employee name. See five methods: (00:13) Introduction [Read More >>>]
DESCRIPTION Learn about the Power Query Function Number.ToText to use some Excel Custom Number Formatting and Power Query Custom Number Formatting to format numbers and convert then to text. WORKBOOKS
DESCRIPTION In this video learn about how to import multiple Excel files using Power Query (Get & Transform): (00:15) Introduction (01:32) Files used for Import (02:46) Multiple Excel Workbooks with Multiple Sheets (03:50) Get “City” [Read More >>>]
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.