autofill gaps in download list in excel with information from cells above

[jharte1225]

Hello

I am struggling to remember how to autofill a list. Please see below. This is a dump of information. I am trying to autofill the gaps with the data from the cells above. Is there a quick way to do this please by maybe inserting a column and adding a rule? The sheet is 1000's of lines long so copy and paste not efficient.

Thank you

C_AR - Argentina

C_AT - Austria

C_AU - Australia

C_BE - Belgium

C_BG - Bulgaria

[#2]

@jharte1225 

Select the entire range.

Press F5 to display the Go To dialog.

Click Special...

Select Blanks, then click OK.

Look at the name/address box on the left hand side of the formula bar and note the address of the active cell.

Let's say that it is A2.

Enter the following formula, and confirm it by pressing Ctrl+Enter to populate all selected cells.

=A1

(A1 is the cell above the active cell)

[#3]

@jharte1225 

The Go To Special solution offered is the best approach.

If one must have a formula and working in 365:

=SCAN("",A1:A50,LAMBDA(a,v,IF(v="",a,v)))

[#4]

@Hans Vogelaar thank you for your reply. It’s very helpful. I have been able to select all the blanks very quickly however after selecting the cell above the active cell, and then hit control and enter, the gaps are not filled. How do I overcome this please? 
thanks in advance 

[#5]

@jharte1225 

1) After selecting the range.

2) After F5, Special..., Blanks, OK. Note the cell address.

3) After entering the formula =A1 and pressing Ctrl+Enter:

[#6]

Excellent thank you :smiling_face_with_smiling_eyes:
Much appreciated. J