title: Excel Vba run Through Table
body: <p>I want to scroll a cell until it is empty and then jump to the next column and repeat this. I am still new, so I have difficulties.</p>
  <p>There are 2 different codes. I do not know which one is closer to the solution....</p>
  <pre><code>For i = 1 To 1000
      If Cells(i, 2) = &quot;&quot; Then
      For j = 1 To 1000
          If Cells(2, j) = &quot;&quot; Then
      Next
  Next
  
  
  For i = 1 To 1000
      If Cells(i, 2) = &quot;&quot; Then
      
  Next i
  </code></pre>
  <p>This is the Basis</p>
  <p><a href="https://i.stack.imgur.com/whX2k.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/whX2k.png" alt="enter image description here" /></a></p>
  <p>And it must look something like this</p>
  <p><a href="https://i.stack.imgur.com/mt9O7.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/mt9O7.png" alt="enter image description here" /></a></p>