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

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

Sample Dataset.xlsx

Datasets

Parse

Data Investigation

Accepted answers

Hello @ManuMittal ,

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

Group and Cancat.yxmd

Hi @ManuMittal , replace the source file with yours.

Thanks.

concatrows.yxmd

Sample Dataset.xlsx

All comments

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

Attached @grazitti_sapna

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

Attaching the workflow along with this post for reference.

Thanks.

concatrows.yxzp

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

Thanks in Advance

Quick Links

Tags

This months top contributors

atcodedog05 19458

Qiu 15866

MarqueeCrew 13708

apathetichell 13703