Rearranging cells into certain columns

[thelinds]

Currently, I have an excel spreadsheet that looks like this:

A B
C
Pamela Potter Kris Sautter Anita Serda
Assistant 1 Assistant 1 Assistant 1
Continuing Educ Division of Academic Affairs Admissions Office

Where Row 1 is the Name, Row 2 contains the persons Title, and Row 3
contains the department in which they are located.

There are about 300 rows that look like this, and I need them to be
sorted out into name, title, and department columns (for a mail merge)


Any ideas??

 

[Tieske]

I assume your rows are repeating? so row 1,2 & 3 belong to eachother, row 4,
5 & 6 together, and so on. Then horizontally there are only 3 columns?

I just sent you an example sheet that does the job.

regards,
Tieske