Combining Rows of SKUs

[Phil_L]

Dear All,

I have been searching the web like crazy --- going crazy too...
I am running with a similar issue (parts related link below) - I have a large (bike) parts CSV where each SKU is relevant to a particular bike, (make, model etc), plus manufacturer. I need to condense these numerous rows (80,K) into one row for one SKU, with pipe separated application for model, bike, etc -
to better eg, as you may or may not know, one exhaust pipe, fits on a varing number of machines - especially the custom parts we supply. Some parts have 100's of different models that they fit, some very few. but, 80+K SKU's is too many for my little brain to digest manually...

in advance, here's a file demo - of two sku - parts.xls

I hope what I have added in as an attachment is clear?!

many thanks to all in advance.

P.

(picked up from: http://www.excelforum.com/excel-gene...-new-post.html)