Join the Alteryx Community’s Maveryx Summer Cup event! Compete, network with others, and earn your gold through a series of challenges from July 24th to August 11th. Learn more about the event here.
community Alteryx IO Alteryx.com
alteryx Community
Search
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Close
Free Trial

Alteryx Designer Desktop Discussions

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

Merging rows into the same column

NY2BOS
7 - Meteor
‎03-23-2022 07:07 AM

Hi all, 

My data looks like this

ProjectPersonPerson 2Person 3Person 4
Project 1Nick   
Project 1 James  
Project 1  John 
Project 1   Adam
Project 2Adam   
Project 2 Nick  
Project 2  James 
Project 2   John

 

I would like the data to look like this

ProjectPersonPerson 2Person 3Person 4
Project 1NickJamesJohnAdam
Project 2AdamNickJamesJohn

 

Thank for your help.

Reply

Accepted SolutionSolved! Go to Solution.

1 REPLY 1
Luke_C
17 - Castor
‎03-23-2022 07:16 AM

Hi @NY2BOS 

 

You could use a summarize tool like this: 

Luke_C_0-1648044985873.png

 

 

New Workflow2.yxmd
Reply
apply to be an alteryx mentor
Join the tampa, florida User Group
Labels