I have a table with 4 columns:
1. ID (The ID is not unique in this column)
2. Start Time
3. Action (max 8 different values possible, this can change in the future...)
4. Action Time
For each ID I need to calculate the differences between the Action Time of the different actions
In order to do so I need a different structure in my report:
1. ID (The ID should be unique here)
2. Start Time
3. For every separate Action I need a separate column
-> The header should be the name of the Action
-> The value in the column should be the DateTime of the Action
How can I do this with Power Query?
