Forum Discussion
Power Query help: combining fields on multiple rows into a single row
Hello,
I need to import PDF bank statements into Excel, but the description field is multiline:
How do I get Power query to import it correctly, and not assume 1 line = 1 record ?
The rule would be: the description line is to be appended to the previous one until there's a value in the date field or it's the end of the table on the page.
2 Replies
What to do with other fields (Value Date, Debit, Credit) for the records with same Date? End of the page afraid not possible to define if you mean printed page.
- Perhaps this article helps? https://powerusers.microsoft.com/t5/Power-Query/csv-with-records-over-multiple-lines/td-p/1758311
