Creating Multiple Records, from existing records

[VictoriaJones]

I think you can tell how confused I have become by the ambiguous title - I don't even know what to call this question!!

I need to create multiple rows (from existing rows) in a new table based upon an old table with the following structure:
f_id
business_function
business_function_desc
bus_impact_severity
bus_risk_cat1
bus_risk_cat2
bus_risk_cat3
bus_risk_cat4
other_desc
product_type1
product_type2
product_type3
product_type4
product_type5
time_entry_id
temp_nbr_sds
temp_valid_details
CC

For each business risk category/product type, I need to create additional rows, so that the following structure is possible:
f_id
business_function
business_function_desc
bus_impact_severity
bus_risk_cat
other_desc
product_type
temp_nbr_sds
temp_valid_details
CC

I am sure that there is a very simple (and probably obvious!!) way of doing this, which completely escapes me at the moment!!

Thanks
Victoria

 

[VictoriaJones]

Sorry - Light bulb has just come on!!!! Put it down to a bad day!!!

 

[SimonBurrell]

Hi VictoriaJones

So it's my turn for the bad day.

How did you create the new table with the additional rows?

Please advise.

Thanks

Simon