turn rows into columns

S

savbci

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

mpenkala

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

John Collins

savbci said:
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.
Click to expand...

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Transpose not working rows to columns 3
Transfer data from Excel col. A to multiple columns in the same sh 0
Transfer data from Excel col. A to columns B-E in the same sheet 3
Auto filter for multiple columns 2
Combine multiple columns and rows for one record into one row. 2
Macro to convert some columns to rows 3
Move data from first 7 rows from one column A into multiple Columnsthen the next 7 rows 2
Read 500 columns of CSV data into a spreadsheet 1

Top