Need help transforming data from column to row and duplicate row information

[Anonymous]

Hi, 

I need help! I am trying to transform data that looks like this:

To this:

Unfortunately I am working from a system from 2004 and there is no way to modify the layout of pulling the information. Any help you can provide would be greatly appreciated! I am in my second week of a new role and trying to make report pulling efficient and non-existent!

[Anonymous]

Indeed , you'll need to add the year, not sure how you determine it, but for 21, type this in the formula bar:

= Table.TransformColumnNames(#"Table or Last Step Name", each _&"-21")

Then, select your first columns, and under the Transform tab in the GUI, select "Unpivot Other Columns".

That's it!

--Nate

[AlexisOlson · Accepted solution]

It looks like you need to unpivot the month column and then convert Month to Month/Year.

https://docs.microsoft.com/en-us/power-query/unpivot-column