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)
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)