I have an excel file with hundreds of rows as follows:

A1= Name, A2 = George Smith
B1= Firm, B2 = Sears
C1=Phone number, C2 = 519-555-4545

E1= Name, E2= Jane Brown
F1= Firm, F2 = IBM
G1=Phone number, G2 = 905-555-4545

I would like the end result to in 'column' format (so every record on each
row)
Column Headings:
Name/Firm/Phone numbers
George Smith/Sears/519-555-4545
Jane Brown/IBM/905-555-4545


How can i achieve this...i have about 500 records.