How Unpivot two columns of amounts

[gomezc73]

Hi Expert,

    I hope you can help me with this request. 

    I have a file with two amount by month for each code of product:

    a) The first amount is the monthly sales and

    B) The second amount is the accumulated by month.

    Something like this:

code	Description	Jan	Acum Jan	Feb	Acum Feb	Mar	acum Mar	Apr	Acum Apr
AA	Code Red	500	500	758	1,258	996	2,254	1,509	3,763
AB	Code Green	750	750	1,137	1,887	1,496	3,383	2,268	5,651
AC	Code Blue	1,200	1,200	1,800	3,000	2,340	5,340	3,510	8,850

I need convert the file and unpivot the amounts columns to generate two columns of amounts by month.

 Something like this:

code	Description	Month	Monthly Amt	Acumulated Amt
AA	Code Red	JAN	500	500
AA	Code Red	FEB	758	1,258
AA	Code Red	MAR	996	2,254
AB	Code Green	JAN	750	750
AB	Code Green	FEB	1,137	1,887
AB	Code Green	MAR	1,496	3,383
AC	Code Blue	JAN	1,200	1,200
AC	Code Blue	FEB	1,800	3,000
AC	Code Blue	MAR	2,340	5,340

Is it possible?

Thanks in advance

Regards 

[PijushRoy · Accepted solution]

Hi @gomezc73 

Please find the attached PBIX file.
I have used month sort to match your expected data, you can ignore those steps
Please check the Power Query steps

[gomezc73]

I tried repeating all the steps and it worked perfectly. Thank you very much. You are the best.

[gomezc73]

thank you so much for your early response.

 Can you send me the steps, how Pivot the data?. i can't find the option to do that.