Zigfreud
New member
- Joined
- May 24, 2022
- Messages
- 6
- Reaction score
- 0
- Points
- 1
- Excel Version(s)
- Office 365
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 column, like Vendor Number, Vendor Name, Document, Amount etc..
I have attached an example of the source 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 column, like Vendor Number, Vendor Name, Document, Amount etc..
I have attached an example of the source file.
Attachments
Last edited by a moderator: