Excel_2E_Dessert_Inventory
Open the Excel workbook Student_Excel_2E_Desserts_Inventory_AS.xlsx downloaded with this project.
To the right of column B, insert two new columns to create new blank columns C and D. By using Flash Fill in the two new columns, split the data in column B into a column for Item # in column C and Item Name in column D. Be sure that Item # and Item Name display as the column headings, and then delete column B.