Pivot Table

  • Thread starter Thread starter nath
  • Start date Start date
N

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.
 
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
 
Back
Top