Excel document cleaning through Alteryx

[Sivory18]

Hello,

I am fairly new to Alteryx and I need help. As you can see, the output only has rows, but no column. I am wanting to use tool like text to column or something so that it can put the data into columns. 

I have provided an excel with 2 sheets which include the 'raw data' which I need help cleaning on alteryx, and another sheet called 'what I want', which what I want the end result to look like. 

Any help will be appreciated. Thank you

[binuacs]

@Sivory18 one way of doing it

[Sivory18]

Hi @binuacs, thanks but as you can see in the last row (row 5) in "raw data" half of the data is in column A and the rest is in column b, that's why in the screenshot you posted, it comes out as null. Is there anyway to fix that and include it?

[binuacs · Accepted solution]

@Sivory18 try the attached workflow