Turn Individual Month Columns into Months Column (this is a hard one!)

[Fapo]

Hello. I have the following situation:

As you can see, there is a monthly budget (Budget Inicial 2018) per asset account (Cta. Contable). There problem is that the user (this is from an Excel) built one column per month: a column for January (ene-18), a column for February (feb-18), and so on. 

The challenge is to make a Month column, so that the table ends up like this:

Asset Account            Budget Inicial 2018           Month

3456                           14.000                               January

34567                         150.332                             January

23421                         200.000                             February

etc                              etc                                     etc

IMPORTANT: the reason why I deemed this "a difficult one" is because I want to do it entirely on Power BI's ETL, so that the user does not have to worry about any of this.

Thanks you very much in advance!

[Fapo · Accepted solution]

Nevermind, unpivot did the job!

Silly me, duh!

Thanks anyway my friends.

[v-huizhn-msft]

Hi @Fapo,

I am very glad you have resolved your issue by yourself, please mark your reply as answer, so more people will benefit from here.

Thanks,
Angelia