good people, I have a table full of unique id's (as mentioned below) but there are missing values for few id's.

I want a formula/code to fill in the blanks based on the values above and below of any cell.

For example: here there are two empty rows between two unique id~(620006845180).

can anyone help me with filling up these spaces with the same value as above and below. :( I am stuck.

```
    620006845180
    xxxxxxxxxxxx
    xxxxxxxxxxxx
    620006845180
    620006845180

```