Data Manipulation

Hi

I have a sheet which shows some product information and acts as on order form for a customer with several stores.

They complete their individual store requirements in colums next to the product details as per Sheet1 of the atatched example.

I need to convert the data to the example shown on Sheet2 to allow me to inport into our sales system.

I have tried lookups, pivot tables etc. but cant work out how to do this automatically.

Any help would be greatly appreciated!

Thanks

Jules