Looping data

[iuphim]

I'm not sure if this is a VBA issue or a query issue, but I would appreciate any advice anyone can offer.

I have a spreadsheet that has multiple chunks of column headings within the same spreadsheet. In one of the column there are data that are divided by a "|". I would like to find all the data divided by "|" in those column and bring that data down to another column and copy all the remaining columns down with this new parsed data. The amount of "|" varies.

I don't know how to put images in this thing to keep the format I need, so please refer to this download link for the pic of the file.

http://www.megaupload.com/?d=404EA0NH

Example:
CategoryP NumberC NumberColorSizeChair12345456 | 458 | 258Blue14 x 16
Should be
CategoryP NumberC NumberColorSizeChair12345456Blue14 x 16Chair12345458Blue14 x 16Chair12345258Blue14 x 16CategoryP NumberC NumberTypeColorSizeApplicationPaint25668124 | 568WatercolorVaries14 x 16Paper
Should be
CategoryP NumberC NumberTypeColorSizeApplicationPaint25668124WatercolorVaries14 x 16PaperPaint25668568WatercolorVaries14 x 16Paper

Thanks!