Common Data Patterns You’ve Never Dared to Transform – Global #PowerBI Webcast
If you have missed my webcast on Global Power BI User Group, you can now watch the recording, and download the Power BI files (details...
Tag: Unpivot
Split and Unpivot Comma-Separated Values
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...
Unpivot ANY nested table and load to Power BI Desktop
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...
Transform ANY nested table to Pivot Table with function query
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...
Transform a nested table to PivotTable
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 – Transform class schedule to PivotTable
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...
Transform already-pivoted tables to PivotTable (The Definitive Guide to Unpivot with Power Query in Excel)
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...
Unpivot Any table in Excel 2016
My Unpivot series just got published on Office Blogs here. Enjoy reading...
