title: How to remove the entire row with values missing only in some columns?
body: <p>I need to remove all rows with empty columns in excel file using matlab programming. I have multiple worksheets inside a single excel file and the data are in a format as follows:</p>
  
  <pre><code>1 2 3 4 5
  2 3 4 5 
  5 6 7 8 9
  12 13 14 15 16
  6 2 8 4
  1 2 3 5 7
  9 8 34 3
  3 2 7 8 4
  </code></pre>
  
  <p>In the above example, I have empty cells in rows 2, 5, and 7 (all empty cells in column 5). I need to find these empty values and remove rows containing these values i.e. I need to remove only rows 2, 5 and 7. The final output should be like below in an excel file</p>
  
  <pre><code>1 2 3 4 5
  5 6 7 8 9
  12 13 14 15 16
  1 2 3 5 7
  3 2 7 8 4
  </code></pre>
  
  <p>I looked at some solutions, where rows with all zeros are removed but in this case, I have empty cells only in column 5 but I need to remove the row containing empty values. Any help is appreciated.</p>