Excel -Power Query

SHOW FORMULA

Split the Category & Product into two columns

SHOW FORMULA

- 1.2 Unit Price 123 Quantity 1 14 2 3.5 3 ABC Category Product Name Beverages Coffee Dried Fruit & Nuts Dried Plums Dried Fruit & Nuts Dried Pears Dried Fruit & Nuts Dried Apples Dried Fruit & Nuts Dried Plums Beverages Chai 30 4 53 5 3.5 6 18 7 46 8 9.2 9 ABC Salesperson Mariya Sergienko Mariya Sergienko Andrew Cencini Andrew Cencini Andrew Cencini Mariya Sergienko Mariya Sergienko Nancy Freehafer Andrew Cencini Jan Kotas Mariya Sergienko Michael Neipper Anne Larsen Nancy Freehafer Laura Giussani Nancy Freehafer Laura Giussani Laura Giussani 9.2 ABC Customer Name 41666 Company AA 41666 Company AA 41643 Company D 41643 Company D 41643 Company D 41651 Company L 41651 Company L 41647 Company H 41643 Company D 41668 Company CC 41642 Company C 41645 Company F 41667 Company BB 41647 Company H 41649 Company) 41646 Company G 41649 Company] 41649 Company] 41649 Company 41650 Company k 10 12.75 11 9.65 12 40 13 46 14 Baked Goods & Mixes Chocolate Biscuits Mix Candy Chocolate Soups Clam Chowder Sauces Curry Sauce Beverages Coffee Candy Chocolate Beverages Green Tea Beverages Coffee Jams, Preserves Boysenberry Spread Condiments Cajun Seasoning Baked Goods & Mixes Chocolate Biscuits Mix 12.75 15 2.99 46 16 17 25 18 22 19 Laura Giussani 9.2 20 Anne Larsen Dried Fruit & Nuts Dried Plums 3.5