savbci wrote:
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.


The way you describe it, each entry takes up three columns, plus a
wasted column, and two rows. 500 entries would take up 1500 columns
plus wasted ones. How many columns do you actually use?

If there are only six columns actually in use, then cut the contents of
E, F, G and paste it below the last entry of A, B, C. Then use
Autofilter on column A to select "does not equal" "Name". Only the data
entries will remain visible, not the headers. Copy and paste the visible
entries to a new sheet. Then sort the data by Name.

John