Changing spacing

[jswaim]

HI,
I have a problem, which I hope is easy to solve. I have four columns of data. In column A is a model code, column B lists the options of that model, Column C is the color of the model, and Column D is the Trim level.

My problem is that in column B, all the option codes are grouped together and separated by a comma. I can have 35 or 40 option codes in one cell.
What I would like to do is separate each option code in column B so that each option is in it's own cell. The options codes need to go down the column and start over at each new model code. An example of the data is at the bottom of the page.
Thanks,
Jason

CC10703(A1)
AE7,BG9,C42,C7H,DE2,FE9,GU5,LU3,M30,NX7,NZ4,QPR,UE1,UM7,VK3,ZY1,Z83,1WT(B1)
50U(C1)
88V(D1)

CC10703(A1)AE7,BG9,C67,C7H,DE2,FE9,GU5,LU3,M30,NX7,NZ4,QPR,UE1,UM7,VK3,ZY1,Z83,1WT(B1)
74U(C1)
88B(D1)
CC10703(A1)AE7,BG9,C67,C7H,DE2,FE9,GU5,K34,LU3,M30,NX7,NZ4,QPR,R9U,SAF,UE1,UM7,VK3,ZY1,Z83,1WT(B1)
50U(C1)
88B(D1)

 

[VoG]

Try Data > Text to Columns, specifying comma as the delimiter.

 

[jswaim]

that seems to work, but it deletes my data in column c and d. Also, is there a way to make the options go down the column instead of across the rows?

 

[sullyman4]

When using text to columns, insert to the right the number of blank columns that will be needed to accomodate the number of possible models. Then do text to columns

 

[Joe4]

Duplicate. See re-stated question here:
http://www.mrexcel.com/board2/viewtopic.php?t=288254&highlight=