I have a about 20,000 rows of information that read like:

A1 A & E ELECTRICAL SERVICES INC 740-927-3421 51 BEECHWOOD DR SW
B1 REYNOLDSBURG OH 43068
C1 3/31/2012

I need them to read
A1 A & E ELECTRICAL SERVICES INC
A2 740-927-3421
A3 BEECHWOOD DR SW
A4 REYNOLDSBURG
A5 OH
A6 43068

If we can get them to:
A1 A & E ELECTRICAL SERVICES INC
A2 740-927-3421
A3 BEECHWOOD DR SW
B1 REYNOLDSBURG
B2 OH
B3 43068

I can take care of the rest. I have tried a number of things but every option requires me to go through by hand and edit thousands of cells of information.

Additionally is there a good way to delete entire rows that are blank or has page 1, page 2, etc.

Any help would be really appreciate!!!

Ben