Using Excel Power Query to Unpivot Data [Extremely Easy That It Will Shock You]

Most times when data is organized in Excel, it is done in a report format (cross tabulation) since it is easy to understand. Working with this format for further analysis can be an uphill task. It is therefore paramount for [...]