Pivot Table

[nath]

I have a pivot table that creates a table based upon some
data that presents the results based on an employees
number, however employees can have 2 jobs. When the
results of the pivot table are presented, the cell that
has their employee number in merges to the next line:

i.e.

1234 Job1 37hrs
Job2 12hrs
1235 JOb1 37hrs
1236 JOb1 28hrs

Is there anyway of stopping the merge?

TIA

Nath.

 

[Debra Dalgleish]

Select a cell in the Pivot table
From the PivotTable menu, choose PivotTable>Table Options
Under 'Format options', remove the check mark from 'Merge labels'
Click OK