Splitting rows using key words

haroon_sa

Hi All,

i'd problem on splitting the rows using key words of a line.

This is my input 

Jhon- A

Peter- B

Sam- A

Andy- B

I need like this

Jhon- A

Sam- A

Peter- B

Andy- B

Using keywords i need to split into two rows,which tool is perfect for this condition.If it is Possible in Alteryx.

bharti_dalal

Hi @haroon_sa,

I am attaching solved workflow.If you want this in two files you can save the workflow using two output tools. Hope it helps

solutionn.yxzp