From the course: Excel Business Intelligence: Power Pivot, DAX and Data Modeling

Unlock this course with a free trial

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

Pivot and unpivot data with Power Query

Pivot and unpivot data with Power Query - Microsoft Excel Tutorial

From the course: Excel Business Intelligence: Power Pivot, DAX and Data Modeling

Start my 1-month free trial Buy for my team

Pivot and unpivot data with Power Query

“

Okay. So by this point, you should be pretty comfortable with those basic Power Query and query editing tools, those number tools, those text tools, date-specific tools. They're all pretty user-friendly and pretty easy to operate, as I'm sure you've noticed. But there are some more interesting ones and some tools that are a little bit less intuitive to work with. And let's cover a few of those now. We're going to start with pivoting and unpivoting. And it sounds a little bit nebulous, but basically the way I describe it is that pivoting is really just a fancy way to describe the process of turning distinct row values into their own columns. That's called pivoting. Or turning columns into rows, which is called unpivoting. Now, you're probably reading this and saying, okay, I understand all those words, but it's still not quite clicking. At least that was my experience. So hopefully, this visual will help. Picture this little table. We've just got one dimension and one quantitative…

Contents