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.

text to columns but to rows

wonka1234
10 - Fireball
‎02-03-2022 02:36 PM

Hi,

 

Is there a way to make a layout from this to this:

 

wonka1234_0-1643927812155.png

 

Thanks

Labels:
Reply
2 REPLIES 2
binuacs
21 - Polaris
‎02-03-2022 02:41 PM

@wonka1234 

binuacs_0-1643928074530.png

 

SplitNames.yxmd
Reply
Qiu
21 - Polaris
21 - Polaris
‎02-03-2022 02:53 PM

@wonka1234 
We can also use a Text to Column tool

0203-wonka1234.PNG

0203-wonka1234.yxmd
Reply
Copilot AMA
Live Office Hours
Labels
Top Solution Authors
View All