VBA code required to run macro for the following problem.

[nilkan]

I have values in 2 rows that needs to repeat itself if they are blank or N/A is present in the rows.I am showing the example that i require below.


Age (Range) pepsi coca cola Dr.Pepper Crush
0-7 0 0 92 8
15-20
20-30
30-45 100 0 0 0
45-60
60-80
7-15
80-90

I need the values of range (0-7) to repeat in the ranges (7-15) when the range (7-15) is either blank or has N/A

VALUES FROM (30-45) TO REPEAT IN THE RANGES (45-60) AND (6-80) WHEN THEY ARE EITHER BLANK OR N/A