Converting rows to columns?

[harliequin]

Hi! I have a spreadsheet of info with columns titled "Name, Facility, Title" and the rows correspond to those titles. We have 10 facilities and I need the columns to actually be each facility name, then I need the first column to have the title and each name then placed beneath the appropriate facility column. Is there an easier way to do this other than starting from scratch and re-typing everything?

For Example: This is what I HAVE (assume the names are all different):

First Name Job Title Facility
JOHN SMITH Activities Director ABC
JOE SMITH Administrator ABC
JANE DOE Business Office (A/P) ABC
JOHN DOE Business Office (A/R) ABC
JOHN SMITH Activities Director CDE
JOE SMITH Administrator CDE
JANE DOE Business Office (A/P) CDE
JOHN DOE Business Office (A/R) CDE
JOHN SMITH Activities Director FGH
JOE SMITH Administrator FGH
JANE DOE Business Office (A/P) FGH
JOHN DOE Business Office (A/R) FGH
JOHN SMITH Activities Director IJK
JOE SMITH Administrator IJK
JANE DOE Business Office (A/P) IJK
JOHN DOE Business Office (A/R) IJK



and this is what I NEED:
TITLE ABC CDE FGH IJK
Activities Director JOHN SMITH JOHN SMITH JOHN SMITH JOHN SMITH
Administrator JOE SMITH JOE SMITH JOE SMITH JOE SMITH
Business Office (A/P) JANE DOE JANE DOE JANE DOE JANE DOE
Business Office (A/R) JOHN DOE JOHN DOE JOHN DOE JOHN DOE

[mikeTRON]

Are you familiar with PivotTables? You can convert the data that way.