Forum Discussion
Split row into multiple rows, while combining columns
KyleFurner How are the columns named? I would suggest doing an 'unpivot columns' or 'unpivot other columns' in Power Query for this one. If they're named consistently with the milestone name, then you'll get close to what you need after a split/extract on the attribute column.
If they are named "Milestone Name", "Milestone Status" "Milestone Target" you'll have even more success.
If the names aren't helpful, you'll need a bit more custom function but still definitely do this in Power Query, NOT DAX.
Please share sample column names so we can assist further if needed.
Thanks for the quick reply Allison. Sorry if my original post wasn't clear.
The current column names are:
Milestone 1
Milestone 1 Status
Milestone 1 target Date
Milestone 2
Milestone 2 Status
Milestone 2 target Date
Milestone 3
Milestone 3 Status
Milestone 3 target Date
I am looking to take a single row and split it out so that I have one column for Milestone names, one for status and one for date, but need to make sure the status and date for each milestone is in the same row as the milestone name.
I had planned to have three new columns called "Milestone Name", "Milestone Status" "Milestone Target" to achieve this purpose.
I also wasn't sure about using the pivot/unpivot functions as these are just a handful of columns in a dataset that has over 150 columns. Would using the pivot/unpivot function affect these other columns?
Kyle
