'Extract data from 1 column in txt with Power Query
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..
Sources
This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.
Source: Stack Overflow
| Solution | Source |
|---|