How to merge two tables based on 2 similar columns

[Anonymous]

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

[HotChilli · Accepted solution]

Looks like a merge on a Year and Week Number (inner join) but are you wanting something else to happen to the Expired column?

[Anonymous]

@HotChilli Thanks for your reply! Sorry, there was an error with the Expired column. I used inner join successfully! Inner join - Power Query | Microsoft Docs