Forum Discussion
Split row into multiple rows, while combining columns
Hi all, I have inherited a dataset which I need to manipulate in Power BI to track project progress. All information is captured monthly in a single table, so all 150+ columns in a single row. ...
You are welcome. Without your actual data, I really cannot help much.
I understand. I have created a sample dataset which will demonstrate what I mean.
Essentially I have a dataset where each project's monthly reporting data is contained.
I need to create a subset of this data only containing the information from the following columns:
- 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
However, I need to display the data like this:
So I am looking for help to split an this data so that a single row, which has data on multiple milestones for a single project, can be a subset containing a row for each milestone, it's date and it's status. But I don't want to include the extra columns, which in the example above contain data on project RAG ratings, (time/cost/overall status).