Table of Contents Example “Code” column is missing in table 1. “Country” and “Parts” are common columns in both the tables. Some of the countries and parts do not have code in Table 2 (India-Item1, UAE-Item2) Some of the countries and parts have code in Table 2 but do not have quantity in Table 1…
Table of Contents Example “Code” column is missing in table 1. “Country” and “Parts” are common columns in both the tables. Some of the countries and parts do not have code in Table 2 (India-Item1, UAE-Item2) Some of the countries and parts have code in Table 2 but do not have quantity in Table 1…
Table of Contents Task We have to combine month wise sales register spread across 12 files into one single file. 3 Steps Solution Step 1 – Keep all the files in one folder Step 2 – Go to Data Tab –> New Query –> From Folder –> Provide the folder path of the above –> Click Ok…
Table of Contents Download & Install Microsoft Power Query Check the Excel version – Is it 32 bit or 64 bit? Go to File Menu –> Account –> About Excel (visible in the End on first row) Click on the link to download Microsoft Power Query http://www.microsoft.com/en-us/download/details.aspx?id=39379 Click on the Download button Select the 32…