We are celebrating the 10-year anniversary of the Alteryx Community! Learn more and join in on the fun 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

Transpose and combine rows

esabay
8 - Asteroid
‎07-10-2023 06:14 AM

Hi All, 

 

How do I do this output in Alteryx based on the input below. Thank you!

 

Input:

Input  
SpongeSnail
SpongePineapple
SpongeKarate
CrabMoney
CrabWhale
CrabPatty
SquidNose
SquidClarinet
StarfishRock

 

Output:

Output 
SpongeSnail, Pineapple, Karate
CrabMoney, Whale, Patty
SquidNose, Clarinet
Starfish Rock
Labels:
Reply
0 Likes

Accepted SolutionSolved! Go to Solution.

2 REPLIES 2
alexnajm
18 - Pollux
18 - Pollux
‎07-10-2023 06:16 AM

Concatenating via a Summarize will complete this!

Transpose and combine rows.yxmd
Reply
0 Likes
esabay
8 - Asteroid
‎07-10-2023 06:29 AM

Thank you! It worked

Reply
Copilot AMA
Live Office Hours
Labels
Top Solution Authors
View All