Transform Data in Power Query using the Unpivot and Pivot Functions

As you know, we can get data in all forms and shapes and sometime it's simply NOT possible to use the data directly as we receive it. In these cases, Power Query comes to our rescue to help us shape…