Every other row into new field

[ZoeM]

Hello Experts!
Super simple, how can I get every other row into a new field Then delete out the blanks?

In the example below, I woudl like to first delete out any blank rows in the data set (row 2 in the example) and then from there have every other row go into a new field so that the end result is as below as well?

Data:

This is a

So use Alteryx

very simple issue

End Result:

This is a	So use Alteryx
very simple issue	to solve it

[markcurry]

Hi @ZoeM,  once you've filtered out the blank rows, you can simply use the 'Make Columns' tools to create 2 separate fields.  Either search for the tool in the search part in the top right, or you'll find it in the Laboratory tool palette. 

Hope that helps.

[ZoeM · Accepted solution]

Thanks for your response.

I ended up using a Record ID, Multi Row Forula Tool and a Filter Tool with the mod function.