On the Suppliers worksheet, establish a web query to import data from the Red Bluff Golf Course & Pro Shop Customer Supplier Report using Get & Transform. The web page provides data on products shipped to the pro shop. This data updates regularly. The formatting on the report is also problematic and several columns need transformation steps before the data can be used for analysis. Use the URL https:iimedia.pearsoncmg.comiphfbpibp_myitlabipainted paradise resortlpaintedparadiseresort_Websiteipageslsupp|ier.html and the Supplier Report table. Split the Products-Units column using the hyphen as the delimiter. Close and Load the data to cell A1 of the Suppliers worksheet