Varying category types within column

[mikeill]

Hi.

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

​

 

[Derek Brown]

Hello and welcome to The Board.
Have a look at the MrExcel Podcast #261:
http://www.mrexcel.com/Excel_1_Record_on_5_Rows_training.html
Unfortunately the quality is not that good but you may be able to follow it.
And, Good Luck!

 

[mikeill]

Thanks, Derek. That will definitely be helpful, and I was glad to hear it described as a complicated issue. I can't actually see the formulas being used because of the blurry video quality, but can probably look elsewhere.

If still haven't wrapped my brain around how this will work with my data set, but I will post a more detailed reply and/or question when I do.

Have a great weekend.

Mike

 

[Derek Brown]

In case it helps, here is the formula that is entered in cell A3. The others should not be difficult to get from the Podcast.
=IF(B3=1,1+A2,A2)