Hi. I have two sources, Source A and Source B.
Source A:
Name | Account | a | b |
1000 | 1234 | ||
1000 | 1235 |
Source B:
Name | Account | a | b |
1000 | 4 | Hi | Bye |
1000 | 5 | Hello | Peace |
I need to search through Source A and find where the Name = Name from source B. I also need to match where Account from Source A ends in the same number as in Account from Source B. If there is an instance of the match then I need to add the values in a and b from source A into a and b of the source B.
I want Source A to end up as:
Name | Account | a | b |
1000 | 4 | Hi | Bye |
1000 | 5 | Hello | Peace |
I have tried a Find & Replace Tool, but couldn't get it working. Any ideas?