FranktheBank
Member
Hello,
I have two Power Query Tables, with one column that can link (have the same data in both tables) "Financial #" Table A has a "$ committed" column, "$ Spent" column and a "$ Remaining" Column. Table B has only a "$ Spent Column". I need to append or append new Table A adding on only what is not already on Table A. So the result would be like the following:
Table A
Table B
Table C (or merge/Appended Table A)
There are plenty more columns and rows (3K+) and this will be updated monthly so it wouldn't be any easy Vlookup and delete.
Any and all help is appreciated. Thanks
I have two Power Query Tables, with one column that can link (have the same data in both tables) "Financial #" Table A has a "$ committed" column, "$ Spent" column and a "$ Remaining" Column. Table B has only a "$ Spent Column". I need to append or append new Table A adding on only what is not already on Table A. So the result would be like the following:
Table A
Financial # | Committed | Spent | Remaining |
123 | 100 | 50 | 50 |
456 | 200 | 75 | 125 |
789 | 150 | 100 | 50 |
Table B
Financial # | Spent |
123 | 50 |
456 | 75 |
789 | 100 |
890 | 200 |
901 | 25 |
Table C (or merge/Appended Table A)
Financial # | Committed | Spent | Remaining |
123 | 100 | 50 | 50 |
456 | 200 | 75 | 125 |
789 | 150 | 100 | 50 |
890 | 200 | ||
901 | 25 |
Any and all help is appreciated. Thanks