Data Spilling Issue

[ManuMittal]

Hi Champions,

I need your help with the attached dataset, my data got spilled in the multiple lines somewhere 2 or maybe 3. How should i fix please help.

Key : Whenever new line starts it starts with 100

Thanks and Regards

Manu Mittal

[atcodedog05 · Accepted solution]

Hi @ManuMittal ,

Please find the workflow for the fix.

Hope this solves the requirement.

Cheers and Happy Analyzing : )

[ManuMittal]

Thank you so much for the prompt response, Solution worked fine 🙂  

[atcodedog05]

Happy to help : )