Sequence - Blank Cell Add Cell on top

Uses previous cell to see if blank exist then places a sequence

Formula in Cell B3 =IF(A26="",A25,A26)

Example

Number Sequence

A B

2 123456789 123456789

3 123456789

4 322222222 322222222

5 888888888 888888888

6 888888888

7

8 111112222 111112222