title: i need to append the odd row data into even and delete the row
body: <p>I need to append data of the alternate row like D1+D2 into excel, please tell mw how can i do that</p>
  
  <p>I have big excel and i am looking for a VBA so that i can append the odd row data into even row and devel the odd row. </p>
  
  <pre><code>        Surgical        Surgical
  10  $1,800  Unit    8/5/2011    unit
          Surgical        Surgical
  10  $4,000  Unit    9/2/2011    unit
          Surgical        Surgical
  10  $2,000  Unit    8/12/2011   unit
          Surgical        Surgical
  10  $1,250  Unit    8/12/2011   unit
          Surgical        Surgical
  10  $1,517  Unit    8/19/2011   unit
          Surgical        Surgical
  10  $1,250  Unit    8/19/2011   unit
          Surgical        Surgical
  10  $2,000  Unit    8/12/2011   unit
          Surgical        Surgical
  10  $2,200  Unit    8/19/2011   unit
          Surgical        Surgical
  10  $0  Unit    8/19/2011   unit
          Surgical        Surgical
  10  $1,251  Unit    8/12/2011   unit
          Surgical        Surgical
  10  $1,500  Unit    8/12/2011   unit
          Surgical        Surgical
  10  $1,001  Unit    9/1/2011    unit
  </code></pre>
  
  <p>these are in two cell and i wand to add the data into upper one 
  please help me with that</p>
  
  <p>thanks in advance</p>