Merry Christmas! 

Questions

Merry Christmаs! 

Dоwnlоаd the Prоblem1.zip file.  Unzip the Question1 Folder аnd copy it to your C:/Dаta folder.  (If using the VDI environment, copy the folder to the Desktop) There are three files inside the folder that contain product information from three different product categories.  Start with a new Excel Notebook and create a Power Query that will do the following: 1. Combine the three files in the folder into one list of products.  Each file uses different column names, so the column names will need to be normalized to a single value.  Use the values in the Bikes files.  You may use any method that is effective in normalizing the column names, and you can assume that any other files that are added to the folder will have similar column names in the same order as the other three.  The query should still work if other files are added to the folder in the future.  2. Extract the size from the product number and create a new column to hold the size.  The size will be the numbers or characters after the second dash in the product number. If the product number has only one dash, then there is no size, and the size value should be null.  The product number should not be changed.   3. Add a new column that will contain the product cost margin, which can be calculated by subtracting the Standard_Cost from the List_Price.   4. Name the query "Products" Load the result of the query into a worksheet in the workbook.  A correct query will result in a worksheet similar to the image shown below.  Save the Workbook with the Power Query as "Problem1.xlsx" and upload it to this question.