In case you missed the announcement: Alteryx One is here, and so is the Spring Release! Learn more about these new and exciting releases here!

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Splitting out names from column and duplicating row

RCern
8 - Asteroid

I have a list of customers that have contact names and emails all contained in the same columns.  Some companies have multiple contacts listed in one cell that I would like to split out into their own row and duplicate the company information for that new row.  I have a sample dataset that shows how my initial data is setup and the end goal/result I am looking to achieve.  Can this be done in Alteryx?

2 REPLIES 2
binuacs
21 - Polaris

@RCern One way of doing this

binuacs_0-1686610449012.png

 

RCern
8 - Asteroid

Thank you!

Labels
Top Solution Authors