How to fill empty cells with a sequence of numbers?

I have been facing this problem for a long time. Sometimes i get excel files that only some of cells have value and i need to fill empty cells with sequence of numbers. for example see following...