sql: extracting values from a delimited string

[B@Th*nG]

hi guys,

I've built a table which has a list of , delimited products in it and the product category they belong to.

product cat | products
Productcat1| product1,product2,product3,product4


I want to extract the values in the products field and build a list of products and their relevant category, just to a temporary table like the below so I can concatenate the 2 fields:

Product | product cat
product1|productcat1
product2|productcat1
product3|productcat1

etc.. does anybody know how? I'm a massive noob at this so be gentle

Many thanks,

B@