STEP 10:Select the 1 and filter out the CUSTOMER heading and press OK. Remove the Content column by Right-Clicking and choosing Remove STEP 9: Now it is time to transform the data by making some cosmetic changes! This imports all the columns’ data from within the workbook STEP 8: Click on the Expand Filter from the Import Data column and select OK. This will import the workbook from the folder STEP 7: You now have a new column called Import.Ĭlick on the Expand Filter and select the Data box only and press OK. This will import the workbooks from within the Folder that you selected in Step 3 Import, and within the Custom Column Formula you need to enter the following formula: = Excel.Workbook() In here you need to name the new column E.G. STEP 6:This will bring up the Add Custom Column dialogue box. STEP 5: You need to go to Add Column > Add Custom Column
![excel 2016 query editor insert a new step excel 2016 query editor insert a new step](https://www.airweb.org/images/default-source/news-images/tech-tips/february-2020/ttfeb2020a.png)
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
![excel 2016 query editor insert a new step excel 2016 query editor insert a new step](https://excelunlocked.com/wp-content/uploads/2020/12/Get-Data-From-Table-Range-Navigation.png)
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
![excel 2016 query editor insert a new step excel 2016 query editor insert a new step](https://support.content.office.net/en-us/media/d7e60d22-a9f4-46ec-bb7a-9f5ee129654e.png)
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.