Tom, just got into the office. The sample workbook helped a great
deal! I exported the data, keyed your formula, and set up the pivot
table. Works like a charm!

I must have misread your first reply, thinking that shift and category
had to be in every other row. My apologies.

You've helped me a great deal - thank you!!!

Best regards,
Jason