Autofill multiple values within the same column

Hi there wizards! I am looking for a way to autofill a column with multiple values (with each value having multiple blank spaces below it) without having to double click the autofill square each time.

Capture.JPG

For example, I want 'Diamond' to autofill all blank cells below it and stop before 'High Potential' and then do the same thing for 'High Potential', etc, etc.

Elsewhere, I've seen a solution of clicking the first cell, and then holding CTRL+SHIFT+DOWN and then using CTRL+D to autofill down, but unfortunately this method also highlights the next cell after the last blank one.


Thank you!

It's actually not a pivot table, it just appears this way as this is how our querying software exports data.

Hi zachwalkerpintoL

Highlight your table.
F5
Special
Go to "Blanks"
OK
equals
Up arrow
CTRL with enter.

This enters cell references. Paste back as values if you like.

Pete