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

Transposing assistance required

Sanathana
5 - Atom
‎07-01-2021 12:48 AM

Sorry for the silly question , but not sure how I can do the below in Alteryx.

 

Input data
TaskEmail ID
Salesram@gmail.com
Salessharma@gmail.com
Salesjohn@gmail.com
Operationslaxman@gmail.com
Operationsjohn@gmail.com
Mediabarbie@gmail.com
Mediaivon@gmail.com

 

Output required
TaskEmail ID
Salesram@gmail.com;sharma@gmail.com;john@gmail.com
Operationslaxman@gmail.com;john@gmail.com
Mediabarbie@gmail.com;ivon@gmail.com
Preview file
10 KB
Labels:
Reply
0 Likes

Accepted SolutionSolved! Go to Solution.

2 REPLIES 2
surajmthomas
8 - Asteroid
‎07-01-2021 09:59 AM

@Sanathana I suppose this is what you are looking for 

 

surajmthomas_0-1625158757110.png

 

CrossTab_Transpose_Community.yxmd
Reply
Sanathana
5 - Atom
‎07-01-2021 10:09 AM

That worked! thank you...

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