Some you may get bit complex Data in Excel. The Data with Merged Cells, Blanks, Multiple Column Headers, Some Time Data Title as Column Headers etc. This kind of Data will not even allow you to create a basic Pivot Table and Cleaning that data within Excel some time really tiring. Data Normalization techniques help us to deal with tough datasets.
Power Query is very Powerful tool to Transform any kind of Data with Few Table Functions and Few quick steps.
In this Video I have covered
Table Functions -
- Pivot, Unpivot Columns, Unpivot other Columns, Promote Column Headers,
Transpose
List Functions
- List.Sum , List.Distinct
Also discussed how to handle Lists in M-Query and few interesting tips.