STEP 4: This will open up the Query Editor.įrom in here you need to select the first 2 columns (hold down the CTRL key to select) and Right Click on the column heading and choose Remove Other Columns This is how you can use Power Query load multiple files from folder feature. This will bring up the Browse for Folder dialogue box and you need to select the folder you created in Step 1 and press OK. STEP 3: From the Folder dialogue box, click the Browse button STEP 2: Open a NEW Excel Workbook and go to Power Query > From File > From Folder
Move an Excel Workbook in this Folder that contains your Sales data e.g.
STEP 1: Create a New Folder on your Desktop or any directory and name it to whatever you like e.g.
