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

recoilx
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

@recoilx One way of doing this

binuacs_0-1686610449012.png

 

recoilx
8 - Asteroid

Thank you!

Polls
We’re dying to get your help in determining what the new profile picture frame should be this Halloween. Cast your vote and help us haunt the Community with the best spooky character.
Don’t ghost us—pick your favorite now!
Labels