Hi,
I have some data that I am trying to separate into individual cells. I have four columns of data. A,B,C, and D. Each row pertains to an individual model (product). So in Column A, I have model codes listed, Column B, is where the options that are unique to the particular model. Column B is where I am having trouble.
A B C D
Model Options Color Trim
CC10906 AG1, B30, FE9, ETC. 59U 193
CC10906 AE7, AJ1, 41U 19D
I need to separate the option codes in column B into individual cells going down the page. I would like the options to carry down the page until they are exhausted and then populate column A with the next Model Code and start the process all over again. I hope I am making sense here.
Thanks for any advice,
Jason
I have some data that I am trying to separate into individual cells. I have four columns of data. A,B,C, and D. Each row pertains to an individual model (product). So in Column A, I have model codes listed, Column B, is where the options that are unique to the particular model. Column B is where I am having trouble.
A B C D
Model Options Color Trim
CC10906 AG1, B30, FE9, ETC. 59U 193
CC10906 AE7, AJ1, 41U 19D
I need to separate the option codes in column B into individual cells going down the page. I would like the options to carry down the page until they are exhausted and then populate column A with the next Model Code and start the process all over again. I hope I am making sense here.
Thanks for any advice,
Jason