I have to copy and fill empty roughly 5 empty cells below each cell with data in it, is there a way to automatically copy the cell data downward to each empty cell until the next cell with data is reached? and the repeat the process for the next cell with data downward?
here in this example, each cell with data needs to be copied down to the empty cells, apart from copy drag is there a function that can do this? because I have 330 of these data lines that need copying down..
Screen Shot 2016-09-09 at 10.21.12 PM.png
Bookmarks