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 |
