Barbara asks you to organize the data for sportswear retailers into an Excel table. The data is currently stored in a text file and is organized by state. You will begin by creating an Excel workbook and then pasting the data from the text file into a worksheet.

Complete the following:

1. Open the initial data fileSportsRetailers.xlsxand save as7-1-Sportswear-Retailers- YourName.xlsx.

2. Create list of comma-separated values from the data you pasted by concatenating the company name, street address, city, state, ZIP code, and phone number. Separate the name, street address, city, state, ZIP code, and phone number information with commas. Trim each text string in the concatenated value to remove all spaces except for spaces between words.

3. Use the appropriate functions to identify the rows of data that hold the concatenated values in the correct order.

4. Copy and paste the concatenated information as a list of comma-separated values into a new worksheet named CSV in the Sportswear Retailers.xlsx workbook. Delete all invalid rows and columns that do not contain the comma-separated values.

5. Convert the comma-separated values into a structured list with the data for the company, street address, city, state, ZIP code, and phone number appearing in different cells of the worksheet. (Hint: Run the Convert Text to Columns Wizard twice to convert all of the data, being careful not to overwrite ny existing data in the process.

You can use this process to separate the state from the ZIP code. Be certain to remove any extra spaces remaining at the beginning or end of the data.)

6. Correct any errors in the data that were introduced during the conversion.

7. Add a header row with labels to describe the data in each column.

8. Change the data in the worksheet to an Excel table.

9. Sort the data by state, then by city, and then by company in ascending order.

10. Filter the results to display only those companies in Oregon and show the total Number of companies in the state.

11. Add your name and Current Date at the end of the workbook.

12. Save and close the7-1-Sportswear-Retailers-YourName.xlsxworkbook.