Hi All.

I have a query to an odbc to get my sales forecast by Year 1, Year 2, Year 3... and Start year. I want to convert the table to something more usable. Example below. Top is how I get the data, bottom is what I want I have done it in vba, but how to do it in Power query?

Capture.JPG

Thanks
Steve