Download Zipped Folder with All Files: https://excelisfun.net/files/14-M365ExcelClassVideoFiles.zip
This video teaches how to unpivot a cross tabulated table and convert it to a proper table so you can perform data analysis.
This full free Microsoft 365 Excel & Power BI class is taught by Excel MVP and Highline College Professor and can be found here: https://www.youtube.com/playlist?list=PLrRPvpgDmw0nre_bTeBfJWjrnixKoyNtW
This video covers.
1. (00:00) Introduction and video topics
2. (00:25) What is a Cross Tabulated Table and What are Benefits of Converting to Proper Table?
3. (01:14) UnPivot feature in Power Query.
4. (01:52) Table.UnpivotOtherColumns M Code Function
5. (02:21) Sort with Resulting Table
6. (02:32) PivotTable from Resulting Table
7. (02:58) Video Summary and Conclusions
8. (03:12) Closing and Video Links
Song in video: Rock Intro 3 by Audionautix is licensed under a Creative Commons Attribution 4.0 license. https://creativecommons.org/licenses/by/4.0/ . Artist: http://audionautix.com/
#excel #excelisfun #analytics #analysis #dataanalysis #dataanalytics #excelmvp #powerbi #powerquery #powerbidesktop #freeclass #freecourse #freeclasses #excelclasses #powerquery #powerquerytutorial #microsoftexcel #microsoftmvp #datamodel #datamodeling,
#unpivot
#pivottables
#Pivot