The Summer Cup has officially kicked off! Get ready to learn, connect, and compete! Complete Community engagement tasks to earn points and unlock exclusive Summer Cup badges for your profile. Learn more here!

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.

Text to Columns Data

HannahSwain7
7 - Meteor

Hi,

 

I am having issues formatting the data via text to columns and splitting out cells. Attached shows the current status of my data and how I need the output to look.

 

Would anyone be able to assist please?

 

Many thanks,

Hannah

2 REPLIES 2
mceleavey
17 - Castor
17 - Castor

Hi @HannahSwain7 ,

 

A simple bit of Transpose and Regex magic does the trick:

 

mceleavey_0-1638460205516.png

 

mceleavey_1-1638460225642.png

 

Workflow attached.

 

I hope this helps,

 

M.



Bulien

mathieuf
Alteryx
Alteryx

Hi @HannahSwain7,

 

Another way to answer your question with more tools but maybe easier to understand.

Hope this help.

Labels
Top Solution Authors