Filling all the non contiguous blank cells in a column with consecutive numbers
Posted on 2016-08-31
Its first time I am using this website. I have a specific problem I cannot find the solution to anywhere. The data I am trying to fix come from a psychology experiment.
So I have a column of data populated by numbers from 0 to 20. The column has unpredictable blank cells in between those numbers like so:
blank, blank,blank,4,blank,blank,3,blank, blank,blank,blank,5,blankx15, etc
i need to fill all the blanks starting from 0 and incrementing up in each adjacent empty cell up to the next non-empty cell, then move down to the next empty cell and do the same until the end.
This data comes from an application which measures behavioural responses. So each empty cell is a response which the participant was correct, and the cells with numbers are responses which the participant made a mistake, at which point, the total of correct responses is entered into the cell. So the non-empty cell is essentially the sum of all the empty cells above it plus itself.
Thanks a lot.