Seperate the sub row

[tmocrz001]

Hi, with this data, is it possible to separate it to each other dynamically?

Expected output:
100 - Red 
 -120 Tiger

Total - 100 Red

101 - Black

- 102 - Dog

- 103 - Cat

Total - 101 Black

Etc..

[ShankerV]

Hi @tmocrz001 

Can you please paste the input in the source format.

So that the solution can be derived from the expected input format. If I mock up in Text Input, it might be different from actual input via Excel sheet.

Many thanks

Shanker V

[tmocrz001]

Here is the input

[ShankerV · Accepted solution]

Hi @tmocrz001 

Please find the expected output.

Note: The workflow used to achieve the solution is attached which can be downloaded to see how the solution works.

If you believe your problem has been resolved. Please mark helpful answers as a solution so that future users with the same problem can find them more easily!!!!

Many thanks

Shanker V

[tmocrz001]

is this possible even u have many data?

[ShankerV]

Hi @tmocrz001 

To have the structured output.

Use Data Cleansing tool.

[ShankerV]

Hi @tmocrz001 

Please find the same output even if we have more data.

Input was:

Many thanks

Shanker V

[tmocrz001]

Thanks for the answer. But may I ask what if the rows doesnt have spaces? what will be the identifier that you will use?  

[ShankerV]

Hi @tmocrz001 

It will be very difficult. That's why I got the inputs of the sample file and then the workflow was built.

If there are no spaces, the logic to be used will be very different and very complex too.

Many thanks

Shanker V

[tmocrz001]

actually that's my problem, the data doesnt have spaces not like the example i gave 😁.