Alteryx excel cleaning

[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_n | Quote_n 

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 · Accepted solution]

@Sivory18 take a look at the attached workflow it should do the trick

[Sivory18]

Hi @aatalai what would I do if for account number, its just not RIOT12, RIOT13, RIOT17, but also RIOT110, RIO1191, H15344, I18264, I27358 etc