Merge Two Pivot tables in to one

[yarlachiru]

i have two pivot tables in excel, created these two pivot tables using Power Query first table has Employee, Work order number, Forecast hours. Second table has Employee, Work order number, Actual Hours. there are some common Work order numbers in both tables, and some are not. What i want is to create a pivot table with Employee , all the work order numbers from both the tables, Forecast hours and Actual hours in the columns . How to do this using Power query or Power Pivot or just excel.
.

[alansidman]

Fast answers need visual help. Please read the yellow banner at the top of this page on how to attach a file and a mocked up solution.

[romperstomper]

It sounds like a full outer join in power query to me.

[yarlachiru]

i am not being able to share the sample file due to lot of steps were involved in developing power query pivot tables.
I have tried Full outer join, its not working, it is is causing to create irrelevant workorder number rows

[alansidman]

Tough to analyze without seeing the actual issue. Good Luck. No file, no help from me.

[yarlachiru]

can this thread be closed, i dont want answer to this thread anymore, i am using alternative way