Is there a way two merge two tables by month to obtain the expected output table?
<tbody>
</tbody>
Thanks
Balances table: | Manager table: | Expected output table | |||||||||||
Loc | Jan | Feb | Mar | Loc | Jan | Feb | Mar | Manager | Jan | Feb | Mar | ||
6 | 23,939 | 4,552 | 14,490 | 6 | John | Paul | Paul | John | 59,769 | 35,604 | 47,973 | ||
4 | 6,842 | 9,357 | 3,205 | 4 | Mike | Paul | Paul | Mike | 31,737 | 33,373 | 4,709 | ||
12 | 15,573 | 24,154 | 6,361 | 12 | John | Paul | John | Paul | 27,802 | 71,560 | 59,115 | ||
18 | 16,770 | 7,518 | 5,832 | 18 | John | Paul | John | ||||||
10 | 4,620 | 24,296 | 5,496 | 10 | Mike | John | John | ||||||
20 | 18,436 | 10,809 | 18,284 | 20 | Mike | Mike | Paul | ||||||
2 | 3,487 | 23,680 | 22,728 | 2 | John | Paul | John | ||||||
15 | 17,599 | 11,308 | 4,709 | 15 | Paul | John | Mike | ||||||
9 | 1,839 | 2,299 | 23,136 | 9 | Mike | Paul | Paul | ||||||
3 | 10,203 | 22,564 | 7,556 | 3 | Paul | Mike | John |
<tbody>
</tbody>
Thanks