Help with Data

[mclamais]

I have data that looks like this

SKU           Brand        Type                     Model
BRTDR400   BROTHER   MULTI-FUNCTION	MFC-9600 * MFC-9700 * MFC-9800
BRTTN430   BROTHER   MULTI-FUNCTION	MFC-9600 * MFC-9700 * MFC-9800

I would like it to look like this

SKU           Brand        Type                     Model
BRTDR400   BROTHER    MULTI-FUNCTION	MFC-9600
BRTDR400   BROTHER    MULTI-FUNCTION	MFC-9700
BRTDR400   BROTHER    MULTI-FUNCTION	MFC-9800
			
BRTTN430   BROTHER   MULTI-FUNCTION	MFC-9600
BRTTN430   BROTHER   MULTI-FUNCTION	MFC-9700
BRTTN430   BROTHER   MULTI-FUNCTION	MFC-9800

Can anyone suggest a way to do this?

 

[Oldsoftboss]

You should have the SKU and brand details in one table and the models in a related table, then bring to 2 together with a query.

 

[mclamais]

You should have the SKU and brand details in one table and the models in a related table, then bring to 2 together with a query.

Yes, that's true, The thing is I'm not designing it, this is data I received from the supplier of the products, I just want to work with the data and import it into ecommerce software. The difficult issue is the fact that the Model field is in this format [value1 * value2 * value3], between 1 and 20 values. Basically I want to tweak the data for the purpose creating product categories.

I want to end up with

Brand, Machine Type, Model
Canon, Inkjet Printers, iP4500

So with this data in a single table like one I given by the supplier, I need the record duplicated, 1 time for each value in the model column

SKU, Model
BRTDR400, MFC-9600 * MFC-9700 * MFC-9800

And I want to end up with

SKU, Model
BRTDR400, MFC-9600
BRTDR400, MFC-9700
BRTDR400, MFC-9800

My first thought is to do a bunch string manipulation queries, first one getting the first value, second the second value and so on.