I have a sheet with about 20 records. One column is for Company. However the
way the data was compiled only the first record has a value for company and
then there is no value again until the new company e.g

Name | Company

Jones | Acme
Smith |
Nadel |
Catn | WidgetInc
Mazuk |
Barny |
Jones | GNC
Walen |
Smith | CenterFilms
Balboa |

So far I've been doing keystroke combos to select next, select all down to
next, back up one, fill down. This takes a long time and is prone to error.

Is there some command/macro that would do this for me automatically?