Split Concatenate values intp rows.

Question

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.

xx.xlsx

New Workflow2.yxmd

abacon · Answer

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

stj1120 · Answer

Hi @OTrieger

It is not working with Text To Columns tool.

Please check the attached workflow.

OTrieger · Answer

@stj1120

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