Combine two different Sharepointlists into a newly created table

i have two lists which has some similar data. There is calender week columns in both lists which oi have combined in the table using Distinct function. Now i need to get data from other columns into this new table according to the calenderweeks so that i can filter based on different categories.

How can i do this?

Thanks in advance