Table Transformation Question

[jweisel]

In PowerBI desktop, I have created a Web connection to a table of data that appears as follow:

How can I edit the query so that data is organized as illustrated below?

Having just two columns would also work, a combined year/month column and a values column.

Thanks.

[Stachu · Accepted solution]

Right click on the year, and then press 'Unpivot other columns'

[jweisel]

Fantastic! I knew it would be something easy and obvious but just could not get there. Thanks Stachu.

[Stachu]

yes, ite's really straight forward in PowerBI 🙂