Forum Discussion
Solved
Merge Table Columns - Chnaging from a WIDE format to a LONG data format
## IMAGES REMOVED Hi all, I am looking to produce a clustered bar chart with product type on the x-axis. My data is in the format displayed in the attached image. I would like to create a new t...
HI HLST
Can you first Unpivot the Green columns of your table in the Power Query?
https://radacad.com/pivot-and-unpivot-with-power-bi
Then you can add some custom column and achive that output.
If this post helps, please consider accepting it as the solution to help the other members find it more quickly.
Appreciate your Kudos!!
LinkedIn: www.linkedin.com/in/vahid-dm/
VahidDM
Super User
Super UserHI HLST
Can you first Unpivot the Green columns of your table in the Power Query?
https://radacad.com/pivot-and-unpivot-with-power-bi
Then you can add some custom column and achive that output.
If this post helps, please consider accepting it as the solution to help the other members find it more quickly.
Appreciate your Kudos!!
LinkedIn: www.linkedin.com/in/vahid-dm/