Forum Discussion

Maxitco's avatar
Maxitco
Helper I
3 years ago

Excel - Power Query - Bank Statements - Combining Data based on Date Values, Type, Descriptions

Hello All,    I am attempting to combine all my historic bank statements together by using Power Query.  I have already selected the source folder to bring 2 months of PDF bank statements to try ou...
General Comment
Need Help
Show and Tell
Tips and Tricks
Tutorial Requests
Maxitco's avatar
Maxitco
Helper I
3 years ago

Hi jbwtp 

 

Many thanks for your message.

 

I have added the new source code and this has created a new name as "Query1" , and the result is shown below. 

 

 

 

Question: I need some further clarification on how to implement the step as per your instruction below in Red to update the transaction descriptions to the source folder data:

 

and replace the content of the new query with the code below, then replace the Source ste pcontent to a reference to your original query:

 

Regarding the secon pages not pulling through, I may have to just add these in manually when reviewing the data.

 

Many thanks for your assistance in this as its greatly appreciated.

 

Cheers Max

jbwtp's avatar
jbwtp
Memorable Member
3 years ago

Hi Maxitco,

 

Sorry for the delay, was busy with another deadline.

In your case (as I can see on the screenshot) the first step would look like:

Source = #"HSBC Advance Account" // which is the name of your existing query, which returns the list of transactions from the statement

 

cheers,

John