Forum Discussion
Merging of 2 x tables
Hi Guys 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 q...
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.