Excel Business Analytics Free Course - Forecasting, Linear Programming, Simulation & more. - Basic Excel Business Analytics #36: Power Query to Unpivot Data (Multiple Columns to Single Column)

Download files: https://people.highline.edu/mgirvin/AllClasses/348/348/AllFilesBI348Analytics.htm Learn about using the Unpivot feature in Power Query to take four separate columns of numbers with columns headers that are criteria and convert it into a proper data set with a column for the criteria and a column for the numbers, and then build a PivotTable to calculate the Mean and Standard Deviation for average hours worked per week for different categories of teachers: 1) (00:17) What does Unpivot mean? 2) (01: 31) How to get data in the Excel workbook that contains the Power Query Query into Power Query: either: 1) Convert data to an Excel Table, or Convert data to a Filtered List (using Ctrl + Shift + L, L) 3) (02:56) Unpivot feature in Power Query. 4) (03:13) Rename columns 5) (03:26) Close and Load to a Table in the Excel worksheet. 6) (03:50) Now you can Filter or Sort the Proper Data Set 7) (04:12) Build PivotTable to calculate the Mean and Standard Deviation for average hours worked per week for different categories of teachers 8) (05:53) Summary Download Excel File Not: After clicking on link, Use Ctrl + F (Find) and search for “Highline BI 348 Class” or for the file name as seen at the beginning of the video.