Remember Matrix Reloaded? Me neither. I bet you still remember the pains poorly formatted data can create. In this lesson, let’s take a look at a complicated pivot table format and unpivot it using Power Query. Something like this…
What is in this lesson?
Understanding complex pivoted data structure
Loading the data in to PQ and doing transformations
Using Transpose feature
Merge and split technique
Adding formulas to extract data from the tabluar format
Closing remarks
Watch this lesson [11 mins]
Author: Chandoo
My name is Chandoo. I am going to make you awesome in Excel, VBA, Dashboards, Power BI & Power Pivot and answering your questions.
I live in Wellington, New Zealand. It is a beautiful, small city on the southern edge of the world. I run my own Excel Consulting & Training business from here.
I am married to my college sweet-heart, Jo. We have 2 kids – twins. They are 10 years old now. They are busy creating new worlds with lego bricks or playing or learning. We (Jo &I) are busy with cooking, eating, walking, talking and reading.
View all posts by Chandoo
5 thoughts on “Unpivoting Complex Data -Matrix Reloaded”
Chandoo,
The video and workbook(s) are missing from this lesson.
@ Marek
The content you are looking at is NOT a part of your subscription.
You have subscribed to power BI classes and can access only those lessons and related material in that class room
Chandoo,
The video and workbook(s) are missing from this lesson.
Hey Bill… can you check now?
Thanks all good.
Hi Chandoo, video and workbook are missing again.
Best,
Marek
@ Marek
The content you are looking at is NOT a part of your subscription.
You have subscribed to power BI classes and can access only those lessons and related material in that class room