Understanding about The Pivot, Unpivot and Transpose

While developing a BI report, sometimes information is spread across multiple columns and other times it is packed into rows. There are three powerful Power Query transformations come into the pictur...