I have a spreadsheet that I didn't design with around 4000+ Rows containing
student information.

The !@#$ who designed the sheet organized it like below:
Columns
A: Teacher Name (Only in the Row above the student names)
B: Student Name (In every row except the first)
C: Student ID (In every row except the first)
D: Period (Only in the Row above the student names)

I want the name of the teacher and the period in every row, like an access
table, so I can sort the stupid thing.

I don't want to have to re-type 4000 rows of data.

Is there a way that I can use the copy down function or a macro to recognize
when there is a new teacher/period and change the information as it copies
down the worksheet? Any help is much appreciated.

--
Thanks As Always
Rip