CSV / Excel Editing / Data Entry

Hello - I have an Excel document that needs to be edited according to these instructions: VIDEO INSTRUCTIONS Watch this video: [login to view URL] TEXT INSTRUCTIONS In one column, there are a variety of categories and child categories that are associated with a product. The majority of the products have three levels of categories, but I need the parent categories to also be listed. For example, here is a category list entry for one product: "New Arrival;Brands/Nike Basketball/Foamposite;Sizes/12;Brands/PRE-OWNED" In the example above, we're interested in "Brands/Nike Basketball/Foamposite" since there are three levels (1) Brands (2) Nike Basketball (3) Foamposite. In this case, we need to add the second level category to this product, which is "Brands/Nike Basketball" The revised category entry needs to look like this (make sure to end the entry with a semi-colon ";" "New Arrival;Brands/Nike Basketball;Brands/Nike Basketball/Foamposite;Sizes/12;Brands/PRE-OWNED" There are around 2,500 entries that need to be updated. If you see only a two-level category, you can skip that entry. There are four parent categories in total that will need to be added. Brands/Air Jordan Brands/Nike SB Brands/Nike Basketball Brands/Other Brands Also, there are a few entries already updated, including only some products have two levels of categories. And if the parent category is already listed, you can skip that entry. Please, let me know if you have any questions. And if you haven't watch the video above, please do that as well. Thank you for your time. - Shawn