hello,

I need a help from people proficient with excel macro !

I have a list,

Column 1 Column 2

data 1 ram, shyam, hari, manori
data 2 sita, gita, rita, mita, nita

I want to format my list as:

Column 1 Column 2
data 1 ram
data 1 shyam
data 1 hari
data 1 manori
data 2 sita
data 2 gita
data 2 rita
data 2 mita
data 2 nita

I think it can be easily done with macro ! Please help !