How to convert txt file into Excel

Question

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?

Divya1808 · Answer

@Raj Here's the sample file

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

Sample_FA_.txt

Raj · Answer

@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.

txt to excel.yxmd

Raj · Answer

@Divya1808 
add a sample text file.