Let’s talk Alteryx Copilot. Join the live AMA event to connect with the Alteryx team, ask questions, and hear how others are exploring what Copilot can do. Have Copilot questions? Ask 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 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
‎02-23-2025 04:45 PM

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. 

Preview file
8 KB
Labels:
Reply
0 Likes

Accepted SolutionSolved! Go to Solution.

3 REPLIES 3
alexnajm
18 - Pollux
18 - Pollux
‎02-23-2025 04:51 PM

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

Reply
0 Likes
Sivory18
7 - Meteor
‎02-23-2025 05:33 PM

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.

Preview file
10 KB
Preview file
27 KB
Reply
0 Likes
alexnajm
18 - Pollux
18 - Pollux
‎02-23-2025 05:36 PM

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

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