replicate rows in excel

i have a data frame like ;

1/4/2015 2 CREDT CARD SETTLEMENT

1/4/2015 3 Cash

1/4/2015 4 Cash 1/4/2015 5 Cash

1/4/2015 6 Cash 1/4/2015 7 Cash 1/4/2015 8 Cash 1/4/2015 9 Cash

1/4/2015 10 Cash

i wish to replicate the gaps in a way that they are filled by the previous number.

more specifically, i want this in the below format.

1/4/2015 2 CREDT CARD SETTLEMENT 2
2
2
2
2
1/4/2015 3 Cash 3
3
3
1/4/2015 4 Cash 1/4/2015 5 Cash 5
1/4/2015 6 Cash 1/4/2015 7 Cash 1/4/2015 8 Cash 1/4/2015 9 Cash 10
1/4/2015 10 Cash

i am a fresher in excel. please help. any simple explanation is welcome.

- - , .
.

Recent Questions...