Hi there, I’m looking for some guidance on how to split up the names in one field and then make the remaining column columns on that row repeat, but with each name getting their own row.
For example, I have some relationship managers who partner with the same individual within a department. When running metrics, I need each relationship manager to show on a row themselves so each can receive credit.
This is how the data shows in our CRM:
![Row repeat.jpg Row repeat.jpg](https://community.alteryx.com/t5/image/serverpage/image-id/323514i330651AEE63B0AA0/image-size/large?v=v2&px=999)
This is what I would like a workflow to do for me.
![row repeat 2.jpg row repeat 2.jpg](https://community.alteryx.com/t5/image/serverpage/image-id/323515i2A4A425982E5681C/image-size/large?v=v2&px=999)
Thanks in advance for everyone’s help.