From the course: Excel: Power Query (Get & Transform) (2020)
Join today to access over 22,600 courses taught by industry experts or purchase this course individually.
Pivot—Don't aggregate
From the course: Excel: Power Query (Get & Transform) (2020)
Pivot—Don't aggregate
- [Instructor] We're comparing venues for a friends retirement party. And the data is in this big stack which is not so easy to look at because maybe we want to sort this data by the square footage, or sort it so that the ones that have a kitchen they're on top and the ones that don't are on the bottom. But we don't have information for every venue. Check out Marshall Morris studio. We have information about the wifi, the kitchen, and then the square footage. But then we go down to Atrium, we've got wifi and square footage. We don't know about their kitchen. It would be great if this data looked like a pivot table. But if you know about pivot tables, pivot tables will do sums and counts on your data. We would like this to be converted and our data left alone. And we can do that in power query. Let's do it. Cursor inside a data set. From table slash range. There's the data. Now which new columns do we want?…
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.