Unpivoting Complex Data -Matrix Reloaded

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.

5 thoughts on “Unpivoting Complex Data -Matrix Reloaded”

    1. @ 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

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.