This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
The highly anticipated Alteryx Community tradition is back! We hope you'll join us!
I have columns Client and Contact. Contact that may have comma separated names in it (e.g., "John Smith, John Doe, Jane Doe"). I would like to separate contact out to be one contact per line.
Also, how would you combine it back? (i.e., multiple line to just one line). We have not decided which form is better for us yet.
See attached excel for illustration.
I have 9.2 so if you can have demo yxzp in that, it would be great!
i dont have 9.5 so please refer the below screenshots
One row row to Multiple Rows use Text To Columns tool under parse menu
for Multiple row to 1 use Summarize tool and group by Client and Concat by Contact