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
cola b c d
handle 6 43 106
so it would become
for each row.