Forum Discussion
Sharepoint/Data Manipulation
You can do this in Power Query. Select the team column and then hit 'Split Column by delimiter'. This will split the team columns in multiple columns. Then select all new columns and hit 'Unpivot Columns', then filter out the blanks of the newly created Value column (there won't be blanks in the example data you gave, but I am guessing not every project has an equally large team) and now you have a one to one mapping between project name and team member. So if you have 3 teammembers in projectA, then you now have 3 rows with ProjectA and corresponding teammember name.
Kind regards
Djerro123
-------------------------------
If this answered your question, please mark it as the Solution. This also helps others to find what they are looking for.
Keep those thumbs up coming! 🙂
Resident RockstarYou can do this in Power Query. Select the team column and then hit 'Split Column by delimiter'. This will split the team columns in multiple columns. Then select all new columns and hit 'Unpivot Columns', then filter out the blanks of the newly created Value column (there won't be blanks in the example data you gave, but I am guessing not every project has an equally large team) and now you have a one to one mapping between project name and team member. So if you have 3 teammembers in projectA, then you now have 3 rows with ProjectA and corresponding teammember name.
Kind regards
Djerro123
-------------------------------
If this answered your question, please mark it as the Solution. This also helps others to find what they are looking for.
Keep those thumbs up coming! 🙂
Thanks alot - that worked perfectly.