Fill empty cells with a certain value

[IMIZQUEZ]

Hi everyone,

I'm currently working with a database that has a column with an ID number, but there are some empty cells in between them. Database is sorted in ascending but as I said before there are some empty spaces that I fill manually by dragging the cell until I find the next value and so on. I was wondering if there is a formula or a tip to do this automatically because every time I have to work with a database I have to do this process before making any calculation as all this rows are missing the ID value in their row.

I don't know if I explained myself clearly but to make this clearer I attach a screen shot.

 

[Fluff]

Hi & welcome to MrExcel.
Have a look here Fill in blanks in Excel with value above/below, fill empty cells with 0

 

[Joe4]

There are a few different ways that you can do this easily.
See here for a few: How to fill blank cells with value above / below / left / right in Excel?

 

[IMIZQUEZ]

Thanks everyone that's what I've been looking for.

Regards,

 

[Fluff]

Glad we could help & thanks for the feedback.