I have a number of rows in a spreadsheet. Some have a value in column C, some do not. What I'm trying to do is have the first row with no value in column C scroll to the position directly underneath the header row (the row above the split). See attached for the before and after sheets.
Thanks!