I have a very large spreadsheet where 1 column is a folder path. One path
will be listed, then a random number of blank cells are below it until a
different path is found. What I'm looking for is a command to make the path
fill down into the empty cells below it until it finds a new value, then fill
that value down, etc.