Forum Discussion
Power Query pivot
- 1 year ago
Hi , sabd80
Please , follow below steps
1) Select Volume , Gross Value , Net Value column with help of ctrl key
then go to "Transform" and select unpivot columns then Unpivot only Selected columnsthen your data will look like this
2) After That select source and attribute column with ctrl key together and go to trasnform and select
merge columns and in separator choose space from the option.
Then your data will look like this3) After that select Newly merged column
and click on Transform data "Pivot" and in value section select Value column
and your data will be in desired stateBest Regards,
Govind Sapkade
Data Analyst | Power BI Enthusiast | Microsoft PL 300 Certified Power BI Data Analyst | MS Fabric Enthusiast
🎥Subscribe to my youtube channel for hands on tutorials : YouTube📊Let’s connect on Linkdin : Linkdin
Hi , sabd80
Please , follow below steps
1) Select Volume , Gross Value , Net Value column with help of ctrl key
then go to "Transform" and select unpivot columns then Unpivot only Selected columns
then your data will look like this
2) After That select source and attribute column with ctrl key together and go to trasnform and select
merge columns and in separator choose space from the option.
Then your data will look like this
3) After that select Newly merged column
and click on Transform data "Pivot" and in value section select Value column
and your data will be in desired state
Best Regards,
Govind Sapkade
Data Analyst | Power BI Enthusiast | Microsoft PL 300 Certified Power BI Data Analyst | MS Fabric Enthusiast
🎥Subscribe to my youtube channel for hands on tutorials : YouTube
📊Let’s connect on Linkdin : Linkdin
govind_021 thank you so much for your solution, it worked perfectly.