Complete Data in single field in multiple rows....

[ManuMittal]

Hi Champions,

I received a data where we have all the data in single filed as mentioned below and that too split in multiple rows. Wherever new row starts we have a NULL over there, need your help in combining all the rows until we reach NULL and so on.... Please help 

[grazitti_sapna]

Hi @ManuMittal , can you please share the dataset along with the expected result for better clarity?

[ManuMittal]

Attached @grazitti_sapna 

[grazitti_sapna]

Hi @ManuMittal , I  hope this is what you are looking for?

Attaching the workflow along with this post for reference.

Thanks.

[ImadZidan · Accepted solution]

Hello @ManuMittal ,

Another way besides @grazitti_sapna , to give you more options.

[ManuMittal]

@grazitti_sapna This zip version is not working, seems it is corrupt. Could you please share it gain. 

Thanks in Advance

[grazitti_sapna · Accepted solution]

Hi @ManuMittal , replace the source file with yours.

Thanks.