Link to Amazon M Book: https://www.amazon.com/Transformative-Magic-Power-Query-Excel/dp/1615470832 (Please write a review too)
Download Excel File: https://excelisfun.net/files/EMT1875.xlsx
Learn how to convert to bad data table with records of data in columns to a proper table structure with records in rows using the Pivot Column Power Query Feature. Lean about efficient M Code (functional language behind Power Query) also!
Learn about the difference between the Table.Pivot function and the Table.UnPivot function.
Topics:
1. (00:00) Introduction.
2. (00:26) Compare to what we did in Excel Short Trick 61
3. (01:20) Difference between Power Query Pivot Column feature & Unpivot Column feature: STAR!!!!
4. (01:47) Pivot Bad Table into a Proper Data Set
5. (03:15) Remove Spaces from Identifiers
6. (03:39) Advanced Editor to look at M Code
7. (04:14) Summary
8. (04:20) Check Out My Power Query M Code Book: https://www.amazon.com/Transformative-Magic-Power-Query-Excel/dp/1615470832 (Please write a review too)
9. (04:32) Closing
#excel #microsoft #excelisfun #excelcourse #powerquery #etl #datamodeling #datacleaning #pivot #unpivot #baddata #data #transformdata