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 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!
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
2 Replies
- AlexisOlson
Super User
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