Auto inserting blank cell

I have a excel with huge data which is give below. But somewhere the fields are not exact suppose somewhere add2 content is not there. I want to put a blank cell in front of the Add2 cell automatically. Please help me ...................Thanks a lot

Name Eicher School
Site http://finders.sulekha.com/school-finder/himachal-pradesh/parwanoo/schools/parwanoo/eicher-school.htm
Add1 Sector 6, Kalka Shimla Road
Add2 Parwanoo
City Parwanoo, 173220
State Himachal Pradesh
Tel Phone: (1792)233393
Category Public Schools