0

I have products in a spreadsheet in which some have multiple categories. I need to split those categories in to a new row with the same product information. For example, I have the following:

Product Name | Product SKU | Product Description | Category
Product 1    |   0294929   | Blah Blah           | Fruit
Product 2    |   3939393   | Blah Blah           | Fruit Nuts
Product 3    |   3921322   | Blah Blah           | Chips

I would like it to look like this:

Product Name | Product SKU | Product Description | Category
Product 1    |   0294929   | Blah Blah           | Fruit
Product 2    |   3939393   | Blah Blah           | Fruit
Product 2    |   3939393   | Blah Blah           | Nuts
Product 3    |   3921322   | Blah Blah           | Chips

This is for importing in to a Magento installation. In order to import the products in to multiple categories, I have to duplicate the same Product, SKU, etc for each category.

Hopefully I am making sense. I can easily split the cells in to columns, but I'm struggling to get them in to the next row down.