Forum Discussion
Need help transforming data from column to row and duplicate row information
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...
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
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