From the course: Advanced Power Query
Join today to access over 24,600 courses taught by industry experts.
Dynamic unpivoting for cross tabulated data: Example 2
From the course: Advanced Power Query
Dynamic unpivoting for cross tabulated data: Example 2
- Another interesting application of lists is while working with cross tabulated data. Let's just say that you're working with a cross tab data, and you just go ahead and unpivot the data, which I'm pretty sure that you know of. But what if another column gets added and you get the wrong result as an output? But how do you fix that? Obviously using a list. This is going to be a very interesting application of lists. I'm excited. Let's start. Let's understand this case for just a quick second. So I have this data, which is where we have the products right here in the rows and in the columns, we have different months right here. In between, we have all of the values, and this is actually a cross tab data. In order for me to understand what is the meaning of 10, I have to look up to the columns and understand what month is it, and I have to look left to understand what product is it. This is a cross tab data. In order to fix this data, I would need a format, something like this, which is…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.
Download courses and learn on the go
Watch courses on your mobile device without an internet connection. Download courses using your iOS or Android LinkedIn Learning app.