Split Concatenate values intp rows.

[stj1120]

Hi,

The dataset has some concatenated values in few columns like Typ, Code and Amt and other columns don't have.

I need to split the concatenated values and show them in the distinct rows. Input dataset is in the first sheet of the attached excel file. Second sheet is the output data. 

Kindly check the data and provide the right approach with the data as shown in the output sheet. 

Thanks,

stj. 

[OTrieger]

@stj1120 

You have tool to do just that, Text to Column tool.

[stj1120]

Hi @OTrieger 

It is not working with Text To Columns tool. 

Please check the attached workflow.

[abacon]

Is the output tab how you would like it to be in the final state or is that what you are getting currently?