How to convert txt file into Excel

[Divya1808]

I have a text file which looks like as below :

 

 

I want to convert 100 such files into excel looking like below:

 How to do so?

[Raj]

@Divya1808 
add a sample text file.

[Raj]

@Divya1808 
find the sample to convert text to excel 
you can use this in batch macro to convert your all files.

hope this helps
mark done if solved.

[Divya1808]

@Raj Here's the sample file 

The WF shared doesn't seems to give the desired output