Help in putting data in readable format

[theo28]

Hi,

I have data in the format as attached in original data.txt. I want to convert it into the format as mentioned in Final desired output.xls,But Im unable to do this .Can someone help me out with this. I have like 50000-70000 lines of data similar to original data.txt.

Thanks,
Regards,
theo28

[alansidman]

Welcome to the Forum, unfortunately:

This is a duplicate post and as such does not comply with Rule 5 of our forum rules. This thread will now be closed, you may continue in your other thread.

Thread Closed.