Find when a value in a column changes

[Kim]

This is what I'm trying to do. Don't know if I can do it with functions, buy
hopefully someone can point me in some sort of direction.
I have a .txt file with weekly payroll info. in it. I want to total the
hours and wages and then also bring over SS#, Name and some other info. Here
is an example of the raw data, each row represents a paycheck (there are
other fields like Check # and so forth but they are irrelvant to what I'm
trying to do):

SS# Name Date Hired Date Terminiated Hours
Gross Wages
111-22-3333 Jane Doe 6/26/04 30
300.00
111-22-3333 Jane Doe 6/26/04 15
150.00
111-22-3333 Jane Doe 6/26/04 25
250.00
222-33-4444 John Doe 3/25/01 12/5/05 40
400.00
222-33-4444 John Doe 3/25/01 12/5/05 40
400.00

1st I sort by SS#. Then I use the subtotal command to get total hours and
gross wages. Now I would like to have a sheet that would show just the
totals for Hours and Gross Wages along with the SS#, Name, Date Hired and
Date Terminated. Using the Subtotal command I end up with something like
this:

111-22-3333 Total
70 700.00
222-33-4444 Total
80 800.00

but I need it to look like this:

111-22-3333 Jane Doe 6/26/04 70
700.00
222-33-4444 John Doe 3/25/01 12/5/05 80
800.00

Any suggestions on how I can do this? Thanks in advance for any help you
can provide.