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.

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.

yes i have but i have 500 records and if i transpose there's only 256
columns....

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

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.

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