In this blog, we look at three different examples of pivoted data and learn how you can use Power Query and the M language to unpivot the data, transforming it into a more organized output. If you’ve found yourself stuck with messy pivoted datasets, this tutorial will show you a step-by-step process on how to transform them into a more usable format.
Advanced Unpivoting Tricks in Power Query
