Transposing assistance required

[Sanathana]

Sorry for the silly question , but not sure how I can do the below in Alteryx.

Input data
Task	Email ID
Sales	ram@gmail.com
Sales	sharma@gmail.com
Sales	john@gmail.com
Operations	laxman@gmail.com
Operations	john@gmail.com
Media	barbie@gmail.com
Media	ivon@gmail.com

Output required
Task	Email ID
Sales	ram@gmail.com;sharma@gmail.com;john@gmail.com
Operations	laxman@gmail.com;john@gmail.com
Media	barbie@gmail.com;ivon@gmail.com

[surajmthomas · Accepted solution]

@Sanathana I suppose this is what you are looking for 

[Sanathana]

That worked! thank you...