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 and append data
From the course: Excel: Power Query (Get & Transform) (2020)
Pivot and append data
- [Instructor] Pivoting data in Power Query may not seem like such a big deal, if we've got data, on a Worksheet, we need to Pivot, why not make a Pivot Table. That's fine, but when we're inside Power Query, and there's an intermediate step, where we need to pivot it, being able to do it in Power Query is beautiful. Here are two data sets, we've got City Center Office, Riverside Office, and we were all given time to go out and do some volunteer work. Now we'd like one data set that has the reps along the side, and the days across the top, like the Riverside Office data, but we've got to clean up the City Center Office data so that we can then append the data sets together. Let's do it. My cursor inside the City Center data set, go to Data, from Table/Range. This is the City Center data, to clean this up, the first thing I need to do is fill in those holes in the Day column. With that still highlighted, right-click, Fill…
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.