Delete a blank row below specific data
<p>I need a script (Excel VBA) that will delete a <strong>blank</strong> line in a spreadsheet <strong>below</strong> wherever 'Monday' appears - can anyone help?</p>

<p>In the example below I need the Mondays to be in together (no blank rows)</p>

<pre><code>name    Monday 02 05 16

name    Monday 02 05 16

name    Monday 02 05 16

name    Monday 02 05 16  
name    Tuesday 03 05 16  
name    Tuesday 03 05 16
</code></pre>