Hi, with this data, is it possible to separate it to each other dynamically?
Expected output:100 - Red -120 Tiger
Total - 100 Red101 - Black
- 102 - Dog
- 103 - Cat
Total - 101 BlackEtc..
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
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.
Here is the input
is this possible even u have many data?
To have the structured output.
Use Data Cleansing tool.
Please find the same output even if we have more data.
Input was:
Thanks for the answer. But may I ask what if the rows doesnt have spaces? what will be the identifier that you will use?
