i need help with the excel homework
this is the problem
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 Category in column D. Be sure that Item # and Category display as the column headings, and then delete column B
Solved by Z. L. in 20 mins