Changing Columns and Rows around to sort

J

Jerid B

Excel 2003 - SP2
I have a spreadsheet given to me by a co-worker.
Example:
A1 B1
Name John
Title HR
Department HR

This goes down about 1500 rows. 300 some people are listed. Is there an easy
way to have the Column become a row. Example:
A1 B1 C1
Name Title Department
John HR HR
Joe IT IT

If I could take this sheet and do that it would make life so much easier and
I could sort by it. Is there a good way of doing this?
 
B

Billy Liddel

Jerid

I'd copy it to a blank sheet. Select all the data rows and columns and copy
(Ctrl + C), select the blank sheet A1, choose Edit, PasteSpecial, click the
Transpose Checkbox and click OK.

Regards
Peter
 

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

Sort 2
Match a value to multple criteria both in rows and columns 3
Flip flopping columns and rows 3
Manipulating Text to create HLOOKUP 8
Copy and Paste Between Files 1
How can I loop through a the values in multiple rows 6
How to sort by grouped rows 2
Mass move data in rows to columns. 3

Top