Changing Columns and Rows around to sort

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?

BillyLiddel
Fri Mar 14 18:03:00 CDT 2008

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

"Jerid B" wrote:

> 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?
>
>
>