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 · Accepted solution]

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

[haroon_sa]

@bharti_dalal

Thanks a lot,Thats worked