Excel document cleaning through Alteryx

[Sivory18]

Hello,

I am fairly new to Alteryx and I need help. As you can see, the output only has rows, but no column. I am wanting to use tool like text to column or something so that it can put the data into columns so like this:

Account number | Instrument | Quantity | Price

As you can see in some rows, they either have the header again or "-----" i want to remove that as well. 

here is the raw excel file if you need and a screenshot of what I want it to be. 

Any help will be appreciated. Thank you

[aatalai]

@Sivory18 similar to the previous post, filter to keep only the relevant fields, use regex (updated parse) to split the data and select to only keep the relevant fields.

Please let me know how you get on

[binuacs]

@Sivory18 another method of achieving this