Hello there, I am working through thousands of rows of data.
I want to use Fill>Series>Trend to fill the gaps. At the moment, I highlight from the next row with data in it, the empty rows and then the previous row with data in it. The number of gaps between varies.
Is there a way to get Excel to do this automatically? Perhaps I select the row with data before the blanks, and then get Excel to select the range until it finds the next row with data in it?
So it would select like this:
Thanks for your help.
I want to use Fill>Series>Trend to fill the gaps. At the moment, I highlight from the next row with data in it, the empty rows and then the previous row with data in it. The number of gaps between varies.
Is there a way to get Excel to do this automatically? Perhaps I select the row with data before the blanks, and then get Excel to select the range until it finds the next row with data in it?
So it would select like this:
Thanks for your help.