title: Formula to show only cells with a value and remove blank rows
body: <p>I have a list that's two columns wide that has blank rows in then I'm trying to make a second list that shows only the rows with text in column "B" if column "C" also has a value at the same time removing the blank rows. For example here's my list:</p>
  
  <p><a href="https://i.stack.imgur.com/jFNHum.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/jFNHum.png" alt="enter image description here"></a></p>
  
  <p>sheet 1 is my list and list 2 is how I would like it to look.</p>
  
  <p>I'm correctly using this formula: </p>
  
  <pre><code>=IF(ROWS($B$4:B4)&gt;COUNTA($B$4:$B$13),"",INDEX($B$4:$B$13,AGGREGATE(15,6,(ROW($B$4:$B$13)-ROW($B$4)+1)/($B$4:$B$13&lt;&gt;""),ROWS($B$4:B4))))
  </code></pre>
  
  <p>which removed the blank rows but it shows black cells in column "C" for example:</p>
  
  <p><a href="https://i.stack.imgur.com/nyedM.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/nyedM.png" alt="enter image description here"></a></p>