Separate items in one cell to multiple rows

[mljohn]

I have a list of machine models in one cell on one row.
I want to separate the machine models that are listed together in one cell separated by a comma and put each machine model in it's own row.

How do I do this in Excel or in Visual Basic?

Thanks for your amazing help.

You guys are great.

Matt

 

[MrKowz]

I'm still not sure how your data is laid out. Where is this extra information being pulled from?

 

[mljohn]

Go to this link to see how my data is laid out.

http://www.box.net/shared/deb3ds3tt9

If all the machines that are listed in C1 are separated into their own separate rows (C2, C3, C4, C5, etc), how do I make certain that all the other corresponding fields (A1, B1, D1, E1, etc) are added to the machines that now have their own row?

Can this be automated? I have 700 plus records.

Thanks

Matt

 

[MrKowz]

Unfortunately I am blocked from downloading files at my workplace. I will try to remember to take a look at this later this evening.

 

[mljohn]

Thanks, I don't know how to show you any other way. MrExcel won't let me upload a file or paste an image.