Hi

I need to write a macro that will do the following :

Example
Input

Col 1 Col2 COl3 Col4 Col5 Col6
StockCode 010 020 030 040 050

1818560 1 3 5
1818620 1 2
1818630 3 6 2
1818530 3 1 3
1956220 4 3 2 3

After Macro Out Put

New Sheet
Col1
StockCode
1818560010 1
1818560020 3
1818560030 5
1818620010 1
1818620020 2
1818630010 3
1818630020 6
1818630030 2
1818530010 3
1818530020 1
1818530030 3
1956220010 4
1956220020 3
1956220040 2
1956220050 3

Please be advise that i have approximately 10000 rows to convert.

I urgently require some help

Many Thanks
AQ



*** Sent via Devdex http://www.devdex.com ***
Don't just participate in USENET...get rewarded for it!