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