Assistance needed to restructure .txt data

[Jake5]

Using the attached .txt file as an input, is there a solution for re-arranging this data into a more structured table format within Alteryx?  Ideally, the records would be organized as I have displayed within the attached spreadsheet labeled "Desired Layout".  Thanks.

[binu_acs · Accepted solution]

@Jake5 one way of doing this

[Jake5]

Thank you!  This was exactly what I was looking for.