How to Pivot Column 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.
Pivot columns allow us to aggregate values from a column. It means that we can SUM, COUNT and more with our data field.
Moreover, it also allows us to manipulate fields that we cannot aggregate, such as text-based information (just like example 2 in the video below).
I used an example that many of you will be familiar with. Some or most of the ERP systems are going to produce a RAW export like the one I used as my starting point.
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.