May 22 2023 04:16 AM - edited May 22 2023 04:17 AM
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.
Aug 07 2023 02:06 AM
Aug 07 2023 03:15 AM
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.