May 2017 Update: This article describes a bug that is already fixed in Power BI Desktop, May update. You can now use the Unpivot Only Selected Columns, and...
By now, if you read my previous posts in the series The Definitive Guide to Unpivot in Excel (all posts here), you will feel confident with the following...
Earlier today I shared with you a function query here that unpivots ANY nested table into Excel and transforms summarized tables into a PivotTable. This post...
Get ready to be amazed :) This is the fourth post in the series The Definitive Guide to Unpivot with Power Query in Excel. In this series we walk you...
This is the third post in the series The Definitive Guide to Unpivot with Power Query in Excel. In this series we walk you through one of the coolest data...
Back to school with Excel & Power Query This is the second post in the series The Definitive Guide to Unpivot with Power Query in Excel. For today's post...
This post is the first in a series of posts that will walk you through one of the coolest data transformation features in Excel. If you are not familiar with...