Hello Simon and community,

I have received an excel workbook with about 2,000 products which need to be exported into a CSV format for use in a MySQL web store.

My problem is that the way in which the spreadsheet is formatted seems to use the same column for multiple categories of data. For example, column A

Row one contains the Category/Workbook Page name,
Row B contains the Sub-Category
Row C has item Name
Row D has description
Rows 6 - 13 contain options (in multiple columns)

Here is a link to a screen shot: http://mzoo.org/images/mZooExcel.png

I would like for each column to have a unique data category (ie: item number, item name, category, category-description).

Is this something that I would need to do manually?

Thanks much and wish me luck.

-mike