Pivot table formatting

[ahennema]

I created a pivot table that has employees and then subtotal by pay period with the number of hours worked for each pay period. so I have the following

EMP NAME
period 1 hours
period 2 hours
..... hours
EMP NAME TOTAL HOURS
<repeat for next employee>

Is there a way to turn off the displaying of the EMP NAME at the top of the table. I would like it to look like this instead:

period 1 hours
period 2 hours
..... hours
EMP NAME TOTAL HOURS

 

[ssianh]

How about copying the results from the pivot table onto another sheet and format it whichever way you want it ?

This is what i usually do with the help of the pivot tables to extract information i needed, and from then on, i copy and paste whatever that's presented to me.

 

[ahennema]

I didn't know you could do that, I will try it.

Thanks - Arich