Power Query help: combining fields on multiple rows into a single row

Copper Contributor

Hello,

I need to import PDF bank statements into Excel, but the description field is multiline:

image.png

 

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

@CedricMi 

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.