Merging of 2 x tables

Question

Hi Guys&nbsp;I'm trying to Merge Data from 2 x different tables that I have created during our stocktake.Table 1 has the part numbers and qty's that were counted.Table 2 has the part numbers and qty's that our system showed pre count&nbsp;The issue i'm having is getting it to merge and add the missing part numbers between each report and show zero's where they were missing between the pre and final numbers.&nbsp;I have been watching video's on using power merge for the last 2 days now and each time I try I get a null value.&nbsp;https://ingolf-my.sharepoint.com/:x:/g/personal/wade_ingolf_net_au/EYp-fRZMw7lNmTSNlmPGXG8Bipnb3WWcpScU67bq-aDygA?e=lWkHjc&nbsp;I have included a link to the tables I'm trying to merge. If anyone can help me out. I'd love to learn how it's done for next time I need to do this.&nbsp;Cheers Wade Hardy

abiola1 · Answer

Hello,You can use Power Query to achieve that..Do take a look at the article in the link belowhttps://support.microsoft.com/en-us/office/append-queries-power-query-e42ca582-4f62-4a43-b37f-99e2b2a4813a

sergeibaklan · Answer

v8manic&nbsp;
Merging the tables use Full Outer join (records from both). After that add custom column with row labels - if it's null for Pre use Final row label otherwise Pre. Replace null on zero, remove unused columns and return result into Excel sheet.
Please check in attached file.

Forum Discussion

Merging of 2 x tables

2 Replies

Resources