Extracting Names from column

[Masond3]

Team, 

I need some additional help again. 

AIM: To extract every name from the "Contact person" Column associated to a given id and display each name as an different row where the "Contact Person" has an  "/"

NB: Looking at the data, i can see that the "/" can be butted up against the last name, or there is a space between last name and the "/"

Data Input 

ID	Contact Person
1	Alteryx User/ Alteryx Chat Bot
2	Amazon Chat / Alteryx Chat Bot

Expected Outcome 

Account Number	Contact Person
1	Alteryx User
1	Alteryx Chat Bot
2	Amazon Chat
2	Alteryx Chat Bot

looking forward to your assistance 

Regards 

[Luke_C]

Hi @Masond3 

You could use a text to columns tool and configure it to split to rows:

[binuacs]

@Masond3 Another way of doing this with the Regex Tokenize method