(need a code of vba) I Need to copy the rest of the data of row after empty cell into next empy row from start e.(A1,2.3) : I need to get rest of the data after empty cell into next available empty row of the same sheet. you can review the attached image of input, and output which is required result. Images can clear more that I want



[Input][1]

[Output(required result)][2]


  [1]: http://i.stack.imgur.com/OZCuV.png
  [2]: http://i.stack.imgur.com/NRJdG.png