excel - How to create new row(s) from the value of existing row -

i new site , hoping can me out following problem. learning excel , stata. here problem want figure out using either stata or excel:

this how original data like:

a1 b1 c1 d1 d2 d3  a2 b2 c2 d1 d2 d4 d5 

this how want change above:

a1 b1 c1 d1  a1 b1 c1 d2  a1 b1 c1 d3  a2 b2 c2 d1  a2 b2 c2 d2  a2 b2 c2 d4  a2 b2 c2 d5 

basically, want create new observations based on d1, d2,.... observations of original data have different number of d's. also, don't know how create new rows of observation @ all!