wonderful .that helps a lot!

One other question. .the new pivot table worked, but how do I rearrange the
orders of the paycodes across the top row? The hours under "reg" came out in
the middle, and I want it to be the first column after the ID number.

"Herbert Seidenberg" wrote:

You can create the desired layout with
another Pivot Table, using the same source data.
If you don't have the source data,
you can recreate it as I did.
http://www.freefilehosting.net/download/3aech