Convert to Rows

[fjlorenzo]

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.

Name	Group Members (Direct)
Group1	Adaya, Jonalyn   (Users/Offshore/usps.mail.local);  Buglosa, Jane   (Users/Offshore/usps.mail.local);  DeGuzman, Malou   (usps.mail.local)

[ShankerV · Accepted solution]

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 solution]

 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 solution]

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

[OllieClarke · Accepted solution]

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

[fjlorenzo]

I think I got it. Thank you for your help.

[fjlorenzo]

Thank you as well @Pilsner