moving columns and row data in excel

id like to move data around in my excel file. how can i do it using vba?

i have data in col a -d

some rows have only data in col a, others only data in col a,b, others with data only in col a,b,c and others with  data in a,b,c,d

i need the output file to make x # of rows for each row

example
cola           b       c     d
handle     6       43   106

so it would become
handle  6
handle 43
handle 106

for each row.

thanks!