How to Change a register of one ID with many type of models in columns and change to many rows with ID

How I can change the format of many many rows columns depending on a given number in a table and join with the ID which is related to the table?

I have a register in which ID is assigned one or more models of a product to one or more connectivities as the example in the following template:

ID, EFT 930, ICT 220, DATE, DIAL, DIAL ETH
7070707, 1 , 2, 08/11/2012, 1, 1

I need to change the format of one columns to many rows, assigning each membership number model type as many rows as the number of models in the table are assigned and their communication type and date of installation.

ID, Models, Connectivity, Date
7070707,EFT930S,DIAL, 08/11/2012
7070707,ICT220, DIAL ETH, 08/11/2012
7070707,ICT220, DIAL ETH, 08/11/2012

Thanks for your help

If I understand you correctly

If I understand you correctly try "Text to columns"... It's on the data tab of the ribbon... use "delimited" and select commas as the delimiter

THANKS....

THANKS....