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
