From the course: Excel: Power Query (Get & Transform)
Join today to access over 23,100 courses taught by industry experts.
Pivot and don't aggregate - Microsoft Excel Tutorial
From the course: Excel: Power Query (Get & Transform)
Pivot and don't aggregate
Wouldn't it be great if we could take a big stack of data like this and look at it in a matrix? We've got this data about various coffee shops around the city. Here's Jacques. We've got slow Wi-Fi at Jacques. And if you work there, you want to know about the number of outlets. Are you going to be struggling to get an outlet? Are there no outlets at all? So it says at Jacques, it's sufficient whereas the outlets at Coughing Bean, get it, Coughing Bean, is great. Jacques has food, but only pastries, whereas let's go down, Twitchy Digits, for highly caffeinated people, they have a full menu. Scroll back to the top. So rather than scrolling up and down, we can look at this in a grid and look at just a column of outlets or just the column of food. Let's do it. Cursor is in the dataset. Go to data from Table/Range. Scroll down. Yep. The marching ants have covered our entire dataset. Table has headers. Okay. Now, we have to close the holes in the venue. Right-click, fill down. Now, to pivot,…
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.