From the course: Excel Power User Challenge

Unlock this course with a free trial

Join today to access over 24,900 courses taught by industry experts.

Teaching Unpivot

Teaching Unpivot - Microsoft Excel Tutorial

From the course: Excel Power User Challenge

Start my 1-month free trial Buy for my team

Teaching Unpivot

“

- [Instructor] Your neighbor is all excited and feeling lost, wondering what she's missing. She's heard about Power Query and unpivot and even unpivot with two criteria. Now she wants you to fill her in on what all the excitement is about. That's the challenge. Generate some data and show how to do an unpivot with two criteria, but don't just show the plumbing of an unpivot. Make the case; say why it's a big deal. Let me warn you that in previous challenges like this, I might hide some data so that you don't have to create your own and then I come back and show you the solution by unhiding some data. No, not this time. I'm asking you to please generate your own data, use your creativity, and now it's that time to pause the video, generate the data, and enlighten your neighbor on the joys of unpivot. (upbeat music) Welcome back and I created some data. Let's slide this out of the way. I have Volunteer Hours by month for these volunteers. In this format, we've got one view of the data…

Contents