Hi ,

I have data in this format

Prod_code product jan feb mar
x1 xxx 23 32 34
y1 yyy 45 45 45
z1 zzz 89 89 89

and i need to convert the data in the below format

prod_code product month value
x1 xxx jan 23
y1 yyy jan 45
z1 zzz jan 89
x1 xxx feb 32
y1 yyy feb 45
z1 zzz feb 89
x1 xxx mar 34
y1 yyy mar 45
z1 zzz mar 89

Please help me in write a macro ......