Convert text file to Excel and do formating

I have a report that is in a text file that needs to be converted to an Excel file and formatted properly in to a Flat File. Please see my screen shots for explanation on how I need it formatted. The 'source' text file is in a FIXED WIDTH format so when I tried to import the text file in to Excel some of the columns are split up in to multiple columns. If the text file was a csv or delimited then this would be easy but it is not either of those. This is a large text file, approximately 130,000 lines. If you have a good 3rd party tool for importing or know how to write a custom script you could probably do this job very easily.