Forum Discussion
Reordering data
Hi my current dataset that I get in Power BI looks like this : Project Member SAP SSO Martin SAP SSO Stefan SAP SSO Tom SAP SSO Steve IT-Service Martin IT-Service Steve ...
Use Power Query. Add a column to the data to say which row is which member (Member1, Member2,...) and then use the Pivot operation to get exactly what you want.
My original table has over 1000 rows and every project has a different amount of employees envolved. Isnt there an easier solution?