title: Fill in blank Excel cells using value from another column value but not in the same row
body: <p>I have blank cells in column G and H (the blank cells will always be in the same row as each other) that I would like to fill with cell values from non-contiguous columns, K and L (data always starts in <code>K13</code> and <code>L13</code>).</p>
  <p>For the columns, I know that the range would start on row 13, but the last row of the data varies.
  For columns K and L, column K data needs to go to column G and column L needs to go to column H.</p>
  <p>If for example, I had data in <code>K13:l14</code>, and an empty row of data in <code>G20:H20</code> and <code>G24:H24</code>, is there a way I can copy the data in <code>K13:L14</code> over to the empty cells WITHOUT KNOWING where the empty row of data starts?</p>
  <p><a href="https://i.stack.imgur.com/e4OfZl.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/e4OfZl.png" alt="Need to move the red values over to the blank spaces" /></a></p>