n this step by step video you are going to learn How to unpivot different data type table layouts with the help of power query a advance data analysis tool.
Additional resources.
Data Excel File for practice.:https://drive.google.com/file/d/10ZNwhHW6QEYjKLaeKFZyDdIlR39jgZg-/view?usp=sharing
Time stamp
00:00 Intro
00:39 Different data types
01:08 Easy UnPivot
03:50 Multi Column Data
07:31 Multi column Header table
13:37 Repeating Data table
20:03 Append Queries