I have some files from SAP system. They are exported in .txt. They have the same structure. The idea is to arrange the data into a more user friendly way using Power Query, especially since there are many such files weekly, and we are unable to report based on txt file.
After I have done some cleaning, the data looks like this: PQ image
And have no clue how to continue, to extract the data into a different colum, like Vendor Number, Vendor Name, Document, Amount etc..