How to Unpivot Data in Excel using Power Query

 


Data in a crosstab form is good to use as a report because it’s easily understandable.

But the problem occurs when you need to use it further.

In this situation, you need to put some efforts and spend your precious time to make it re-usable.

In the below example, you can see a crosstab data. To make it re-usable the best way is to UNPIVOT it, yes, just like this one.

And to unpivot data, the best way is to use the POWER QUERY.

So today in this post, I’d like to share with you simple steps to convert a crosstab dat