Hello,
I have the following two tables and i am trying to merge them into a single table by keeping the first 2 common columns and then appending all the other columns. Is this possible? Any help is much appreciated!
First Table
| Year | Week number | Items | Returns | Defective |
| 2022 | 1 | 3 | 4 | 8 |
| 2022 | 2 | 6 | 9 | 17 |
| 2022 | 3 | 2 | 5 | 10 |
| 2022 | 4 | 9 | 3 | 16 |
| 2022 | 5 | 5 | 6 | 15 |
| 2022 | 6 | 2 | 2 | 10 |
| 2022 | 7 | 7 | 8 | 22 |
| 2022 | 8 | 3 | 3 | 13 |
| 2022 | 9 | 6 | 3 | 18 |
| 2022 | 10 | 3 | 3 | 14 |
| 2022 | 11 | 2 | 7 | 17 |
| 2022 | 12 | 3 | 7 | 22 |
Second Table
| Year | Week number | Sold | Excess | Expired |
| 2022 | 1 | 2 | 8 | 11 |
| 2022 | 2 | 6 | 2 | 10 |
| 2022 | 3 | 3 | 6 | 12 |
| 2022 | 4 | 3 | 5 | 12 |
| 2022 | 5 | 7 | 3 | 15 |
| 2022 | 6 | 2 | 3 | 11 |
| 2022 | 7 | 9 | 3 | 19 |
| 2022 | 8 | 4 | 7 | 13 |
| 2022 | 9 | 7 | 2 | 18 |
| 2022 | 10 | 8 | 9 | 14 |
| 2022 | 11 | 5 | 2 | 17 |
| 2022 | 12 | 3 | 6 | 21 |
Results:
| Year | Week number | Items | Returns | Defective | Sold | Excess | Expired |
| 2022 | 1 | 3 | 4 | 8 | 2 | 8 | 11 |
| 2022 | 2 | 6 | 9 | 17 | 6 | 2 | 10 |
| 2022 | 3 | 2 | 5 | 10 | 3 | 6 | 12 |
| 2022 | 4 | 9 | 3 | 16 | 3 | 5 | 12 |
| 2022 | 5 | 5 | 6 | 15 | 7 | 3 | 15 |
| 2022 | 6 | 2 | 2 | 10 | 2 | 3 | 11 |
| 2022 | 7 | 7 | 8 | 22 | 9 | 3 | 19 |
| 2022 | 8 | 3 | 3 | 13 | 4 | 7 | 13 |
| 2022 | 9 | 6 | 3 | 18 | 7 | 2 | 18 |
| 2022 | 10 | 3 | 3 | 14 | 8 | 9 | 14 |
| 2022 | 11 | 2 | 7 | 17 | 5 | 2 | 17 |
| 2022 | 12 | 3 | 7 | 22 | 3 | 6 | 21 |
