Trick : Repeat Entries in a List - Fill the blank Cell With Repeated Text or Number

Trick to Repeat Entries in a List .

Fill the Blank Cells With Repeated Text or Number.

Steps:
a) Select a B:B column.

 b) Press Ctrl+G - Go To Dialogue Box will open.

c) Click on Special and Select "Blanks" option. Click OK.

d) In formula bar write =B3. And press Ctrl+Enter.

And here, you get the desired result. 

Now, Copy the column B:B and paste special it as a values.

Thank You!!