Combine 2 columns of data

[Ramballah]

Hi Everyone,

I'm posting this thread because of my previous thread: Combining 2 pivot tables into 1 chart
Which basically got answered but now I am here with a slightly different question.
I have 2 tabs with both one xpivot table in it which look exactly the same.
In tab 3 I want to have all the different values from column A from both tabs to be in the same list without duplicates.
See my excel file + Screenshots
Tab 1 Tab 2 Tab 3

So I want to have all the week numbers that show up in these 2 pivot tables so I can vlookup the corresponding amounts.
If im not clear enough please ask.
Thanks in advance,
Ramb
My file is here uploaded on easyupload.io

 

[Ramballah]

I should mention that picture 3 is wrong since I skipped week 25-26-27-28-29
Correct picture:

Correct excel file: https://easyupload.io/xjwr9x

 

[Ramballah]

Bump

 

[sandy666]

check this

s666-PQ-Schemas Saldilijsten.xlsx

Microsoft Excel Workbook

1drv.ms

 

[Ramballah]

check this

s666-PQ-Schemas Saldilijsten.xlsx

Microsoft Excel Workbook

1drv.ms

Could you explain what you did? From the looks of it you made more pivots and a query?
I hoped this would be do-able with just formula's so I can save a lot of time with my future workbooks that also require the same look.
also on further exploration, I see that there are week numbers missing from ur pivot..

 

[sandy666]

try again - file updated
this is Power Query only not a Pivot
I can't help with formula

 

[Ramballah]

try again - file updated
this is Power Query only not a Pivot
I can't help with formula

hmm looks like with power query it works but I really prefer this one to be done with a formula that way its easier to explain to colleagues and maintain...

 

[sandy666]

sure, your choice
have a nice day

 

[Ramballah]

sure, your choice
have a nice day

Im sorry,
Have a nice day too.