Splitting out names from column and duplicating row

[RCern]

I have a list of customers that have contact names and emails all contained in the same columns.  Some companies have multiple contacts listed in one cell that I would like to split out into their own row and duplicate the company information for that new row.  I have a sample dataset that shows how my initial data is setup and the end goal/result I am looking to achieve.  Can this be done in Alteryx?

[binu_acs · Accepted solution]

@RCern One way of doing this

[RCern]

Thank you!