Organizing data to sort in a spreadsheet.
 

I import a lot of reports into Excel for quick sorting and manipulation.
Many of these reports "look" pretty when they are printed, but are difficult
to work with in Excel.

Does anyone know how I could take a "header" row with three columns...A, B,
and C and move it down into each of the detail line items below it?
And then if that wasn't enough to ask, how to make this automatically repeat
for each new header row? I have attached a sample spreadsheet showing the
detail. The header line has the employee name in column A, employee number
in column B, and department in column C.

Thank you for helping.

Dave