Need to convert my input file into a specific format

[swarajjoshi]

Hello Everyone,

I have a input file which looks like this,

And I want to convert each row into a specific format, the example for the output format is like this,

Note:- This is just an example where I have manually converted 1st row of the input file to get the result

What I want is to create a block like above for all the 16 entries present in the input file so in the output file there should be 16 blocks one below the other. I have tried various methods but I'm not able to get the desired output.

And thus I'm back posting in this awesome community where I have found answers to many of my problems.
Any help would be highly appreciated.

I'm attaching the input and desired output file for convenience.

[swarajjoshi]

Hey @pdave87 

Thank you soo much man, it was a great  great help.

Cheers, bye

[pdave87]

@swarajjoshi We are happy to help and learning remains to be a continuous process because of this fabulous community.