Hello! I have a Bill of Materials (parts explosion) spreadsheet with data in columns A,B,C,D,E,F&G. Column A is the main part number of the item to build. B is its description, column C is a string of delimited information that follows this format: qty\sub-part number\description/qty\sub-part number\description/qty\sub-part number\description/
for example: 1\200786\BOX/1\300298\COVER/1\MS28775-254\GASKET/1\4TB8\TBrD/
These are the sub parts that go into making the item in column A. The information in columns B,D,E,F& G are specific to the main part number in column A and must remain in the same ROW as the main part number.
However, I need the data string in column C to be separated into columns (by qty, part number and description), insert a row underneath and continue separating the data so that only one qty, sub-part number and description is in each row underneath, and a new row is inserted for each sub-part number.

I have posted example worksheets on www.4shared.com

http://www.4shared.com/file/vHpXokDV/Unfixed.html shows the spreadsheet as it exists now, though much smaller!

http://www.4shared.com/file/9t-xJ-O0/Fixed.html shows how I need to break down the data in the "Unfixed" column C.

I'd really appreciate anyone's help with this!!
Thanks!!