The Los Angeles office provided its monthly data as a webpage file. Import the data from the file Support$\_$EX$19\_$EOM$7-1\_$LosAngeles.html$,$ specifying a path such as c: $\backslash$users$\backslash$usernameldocuments$\backslash$projects$\backslash$Support$\_$EX$19\_$EOM$7-1\_$LosAngeles.html$.$ Select the Wang Marketing: Los Angeles Office data. Use the Power Query Editor to transform the data by removing the first column, and then load the data as a table in the Advertising worksheet beginning in cell A$22.$