I posted this in the wrong section so need to move it here:
I have a pivot table where I am attempting to show employee data, and have the employees listed, but want to show employee number as well. These are in separate columns and to have them viewable properly it won't work. What I get is this:
Division Employee Name Employee Number
1 John Doe
1 John Doe 548547
Can anyone point to a way that I can see only the second line and not the two separate lines?
I have a pivot table where I am attempting to show employee data, and have the employees listed, but want to show employee number as well. These are in separate columns and to have them viewable properly it won't work. What I get is this:
Division Employee Name Employee Number
1 John Doe
1 John Doe 548547
Can anyone point to a way that I can see only the second line and not the two separate lines?