In case you missed the announcement: The Alteryx One Fall Release is here! Learn more about the new features and capabilities here
Start Free Trial

Alteryx Designer Cloud Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Cloud.
SOLVED

NEED URGENT HELP: Separating rows into 3 columns

Sivory18
7 - Meteor

Hi guys, as you can see all the data is in 1 row but need to separate it into 3 columns. I think I have to use the text to column but just don't know what settings to put down. 

3 REPLIES 3
alexnajm
19 - Altair
19 - Altair

What have you tried so far? Have you tried to split by text to columns on the space while also selecting skip empty columns?

Sivory18
7 - Meteor

Could you help me to do with this please. The first screenshots shows the before and the second is what I want to look after.

alexnajm
19 - Altair
19 - Altair

This is a different question, so it may be worth posting this one specifically. 

but similar solution - text to columns skipping empty columns, then you can do your additional splits with a formula tool afterwards