Reordering data

[Jordan11257]

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
Customer Project	Martin
Customer Project	Tom
Customer Project	Steve

For better usage I would like to create a new table (with DAX function?) to align ist like that

Project	Member 1	Member 2	Member 3	Member 4
SAP SSO	Martin	Stefan	Tom	Steve
IT-Service	Martin	Steve
Customer Project	Martin	Tom	Steve

Is this possible and could anybody pls help me? Thank you very much

[Anonymous]

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.

[Jordan11257]

My original table has over 1000 rows and every project has a different amount of employees envolved. Isnt there an easier solution?