Thanks!
This information was very helpful to me!!
Grace

mpenkala wrote:
Hi there,

Have you tried using the 'Transpose' Function in Excel? It allows you to
move data between rows and columns.

- Copy the data in one or more columns.
- Before you paste the copied data, right-click your first destination cell
(the first cell of the row or column into which you want to paste your data),
and then click Paste Special.
- In the Paste Special dialog box, select Transpose, and then click OK.
(You'll find theTranspose check box in the lower-right corner of the dialog
box)

Hope this helps,
Matt P.

"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.