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 data in Power Query
From the course: Excel: Power Query (Get & Transform) (2020)
Pivot data in Power Query
- [Instructor] Now I'm going to show you that we can pivot data inside Power Query. Here we've got data where people were allowed to go out, take some time, do good in the world, and now our director wants to know who actually took advantage of this and how many hours they did volunteer making the world a better place. But we've got this long stack, and notice, Cynthia volunteered two hours and then three hours. We don't want that. We want to see just a five for the hours that Cynthia volunteered on Monday. The best way to give this to our director is in a pivot table form. So let's do that in Power Query. Here we go. Cursor inside the dataset. Data, From Table/Range. Here's the data. Now, in order to pivot this I need to highlight the column that I want as my column headers. That's the Day column, so that we have the days going across. Next, I'm going to Transform, and then Pivot Column. Now it says Use names…
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.