It is so common that we deal with crosstabs in Excel. It is good for displaying summarized data. However, if you need to further analyze the data, especially with PivotTable, you will find a crosstab not the right layout. What will you do then? Move the data one by one to the PivotTable-friendly layout?

I saw my colleague did that before. No kidding. If you are talking about just a few rows and columns, no big deal. Silly but doable. What if there are hundreds of rows and tens of columns in the crosstab? Are you going to spend the entire day just moving cells around?

Power Query comes to rescue. And unbelievably, it can be done in a minute! No kidding!

You may download a sample workbook to follow along:

Let’s watch it in action!

Insanely amazing! Isn’t it? 😉