Power Query question

Basil_58

New Member
Joined
Feb 9, 2021
Messages
1
Office Version
  1. 365
Platform
  1. Windows
I have a specific question that you may be able to answer or point me to a resource.
I have downloaded my CSV statements from my bank(s).
As you know, the CSVs are not consistent between banks or even different accounts from the same bank.
I have done a lot of work in Power Query to make them into proper data sets and remove, replace, reformat the CSVs so they are all consistent with one another and can be merged and/or appended to one master file that I can run reports on.
I am planning on using the same Power Query to format future downloads from the bank.
The problem is that I have a running total of the accounts that I would like to maintain over several years and the same going forward.
There are times that I may have to make changes to the Power Query to accommodate for changes that the bank may make or that I may decide to make for different reasons.
However, when changes are made to the Power Query, the changes I have made to my spreadsheet(s) and Pivot Table(s) will be overwritten by the update from Power Query.
Any ideas of how to retain the data I have changed (i.e. running v-lookup or x-lookup, or just replacing values in the resulting table(s).
Let me know if you can help and I can be more specific.
 

Some videos you may like

Excel Facts

Can a formula spear through sheets?
Use =SUM(January:December!E7) to sum E7 on all of the sheets from January through December

Watch MrExcel Video

Forum statistics

Threads
1,127,531
Messages
5,625,366
Members
416,096
Latest member
forevans

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top