Spreadsheet Layout Conversion

I have received a spreadsheet that has contact data in a typical "business
card" format. An example would be (With row numbers on left):

1 Firstname Lastname
2 Job Title
3 Company
4 Address 1
5 Address 2
6 City, State Zip
7 EMPTY SPACE
8 Firstname Lastname
....

I am trying to find a way to convert this data to a table format such as:
A B C D E
F G H I
1 Firstname Lastname Job Title Company Address 1 Address 2 City State
Zip
2 Next record

Any suggestions on how to make this type of layout conversion?