Forum Discussion
Reshaping Dataset with Power Query
If it's better for you in order to adapt the solution to your necessity here are the steps i used:
- first add a index column
- reorder it to the first column
- select the first 3 column and unpivot other columns
- now you need to replace characters 1 and 2 in order to have a unique DK and PI
- group rows
- add a new index column inside your column of tables
-remove all columns beside the last one
- expand all
- and then finally pivot it again
Hi, thanks for your reply!
I tried it but didn't get the expected result. The problem lies in those "Downtime Key" columns. There are lot's of them due to the fact that each one is recording another downtime event that occurred during a specific job.
Your solution would work for just one column "Downtime Key" and others just with numerical values. (Of course only if I got that right).
Kind regards,
Daniel Kwiatkowski
Sorry if i mistake,
the table i used is like the one you provided and in it there are more then one DowntimeKey
so i think that there is another problem