Help with Edit Query Power BI

Use Unpivot to split the columns into rows.  Promote 1st row to headers

If I'm understanding it correctly you may need to split the volumes and prices, unpivot them then merge together.

Create a copy of orignal source query delete the columns for volumns. In the original query delete the prices.

Give the Columns MonthNo Names as they get turned to attributes.  You can add a computed col to turn the month attribute to a date.

Select ProductName an unpivot other columns on each query

create a composite key from product and date copies of the columns then combine with a delimiter char

Use the key to merge query 2 back to the original and expand to get the price on the row.

Here is a couple of posts on unpivot

http://radacad.com/pivot-and-unpivot-with-power-bi

https://businessintelligist.com/2015/05/19/power-bi-tutorial-unpivot-feature/

I detailed a similar solution to in this post

http://community.powerbi.com/t5/Desktop/Actual-versus-projected/m-p/348465#M156474