Need to reorganize - transpose columns to rows per article number

[toblju]

I have a list with five columns. Every row contains following data:
Column A contains article number. Column B-E contains info about where to find pictures.

It looks like this:
ArticleInfo 1Info 2Info 3Info 4500086S:\ONSTOCK\Produktbilder\09_alabama_blackS:\ONSTOCK\Känselbilder\alabama_1S:\ONSTOCK\Känselbilder\alabama_2S:\ONSTOCK\Känselbilder\alabama_3500087S:\ONSTOCK\Produktbilder\09_alabama_blackS:\ONSTOCK\Känselbilder\alabama_1S:\ONSTOCK\Känselbilder\alabama_2S:\ONSTOCK\Känselbilder\alabama_3

I would like to extract data in a different format.
I would like it to look like this:
ArticleNumberInfo5000861S:\ONSTOCK\Produktbilder\09_alabama_black5000862S:\ONSTOCK\Känselbilder\alabama_15000863S:\ONSTOCK\Känselbilder\alabama_25000864S:\ONSTOCK\Känselbilder\alabama_35000871S:\ONSTOCK\Produktbilder\09_alabama_black5000872S:\ONSTOCK\Känselbilder\alabama_15000873S:\ONSTOCK\Känselbilder\alabama_25000874S:\ONSTOCK\Känselbilder\alabama_3
I suppose I need a macro? My list is about 1200 articles.

Thanks
Tobias

 

[toblju]

Did not look nice on screen. Pls see enclosed file.
Regards,
Tobias.