Convert to Rows

Question

Hi,

Can someone assist me? I have the below data and I want to convert column B to rows for each user name. Thank you for your help.

NameGroup Members (Direct)Group1Adaya, Jonalyn   (Users/Offshore/usps.mail.local);  Buglosa, Jane   (Users/Offshore/usps.mail.local);  DeGuzman, Malou   (usps.mail.local)

ShankerV · Accepted Answer

Hi @fjlorenzo

Could you please use Text to columns tool.

In the Text to columns configuration window, use the below

Delimeters ;

Select Split to rows

Many thanks

Shanker V

Pilsner · Accepted Answer

This should work once you connect your data. Make sure you change the delimiter to be a ; not the default which is ,

Hope this helps

fjlorenzo · Accepted Answer

Thank you @ShankerV . Follow up question, how can I only extract the username for each user?

OllieClarke · Accepted Answer

@fjlorenzo  You can keep it text to columns, and split to columns on ( 
After that use the trim() function to remove the trailing whitespace.