Community Halloween is live until October 31st! Complete any 2 quick activities to earn the 2025 Community Halloween badge. Feeling brave? Check out the activities here
community Alteryx IO MyAlteryx
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
Start 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
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
Community Live Fifa Workshop
Labels
Top Solution Authors
View All