How to Unpivot Columns in Power Query
In this blog series, I’m going to walk you through three really powerful data transformation tools in Power Query.
- Transpose Data
- Pivot Columns
- Unpivot Columns
I believe these are the most important built-in functions you should master before you start exploring others. Additionally, these are readily available using the GUI in Power Query.
Once we cover all three of them I’m going to show an advanced data transformation exercise based on a scenario that many of us probably faced before. It could be replicated by using the video/blog post as a guide.
Moreover, as this series is all about Power Query, the features/functions mentioned throughout the posts are available both in Power BI and in Excel.
Unpivot columns allow us to reverse “Pivoting”. This feature is extremely useful, as in many cases when we receive data from 3rd parties, it tends to be in a pivoted format.
In addition, in case our data is getting updated frequently, we also have the “Unpivot other columns” option. It lets us create an absolutely automated logic, where we don’t have to worry about readjusting our Power Query steps every single time when new data comes in.
I tried to pick examples that many of you will be familiar with.
To be honest, Unpivot Columns is my most frequently used Data Transformation. I am so happy that this is a built-in feature into Power Query, it saves a lot of time!
If you want to learn more, check out the video 👇 below to start your journey with Data Transformation in Power Query.
🙏Thanks for watching and if you liked this video please hit the 👍 button.
📢 Also be sure to subscribe to the channel so you never miss a new video.