From the course: Excel: Power Query (Get & Transform)
Join today to access over 23,100 courses taught by industry experts.
Pivot data in Power Query - Microsoft Excel Tutorial
From the course: Excel: Power Query (Get & Transform)
Pivot data in Power Query
Yes. It is possible to pivot your dataset in Power Query. And that's what I'm going to show you in this video. We'll have some other data to clean up and then you will see how to pivot the data. Specifically, we want to see the office employee, okay, those columns and then the categories going across the top so that we can see wildlife conservation, health and wellness, technology, and college prep as headers going vertically not in this big stack. And then we'll be able to see things like this. Leeza volunteered 6.5 hours in wildlife conservation and three hours in health and wellness. That'll be easier to see once we're done. Let's get to it. Cursor is in the dataset. I'm in the data tab. I want to get the data from Table/Range. With this column highlighted, right-click. Fill down. This column highlighted, right-click. Fill up. I don't need the nulls in the employee column. Okay. Now, here's what we've been waiting for; the pivot. First of all, what column headers do I want across…
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.