I have a excel file of flat data with:
ID, Name, Location, Department, Sun(Hours), Mon, Tue, Wed, Thr, Fri, Sat, Reg Hrs, OT Hrs
When I insert a pivot table, the rows are broken up by Location, within Location - Department and within Department - Name.
The column info is the daily hours and the Reg and OT totals. They are summed for each Department.
I'd like to have the ID and Name combined as a row label. But when I add ID it duplicates the hours info onto a second line.
How can I combine the Name and ID fields onto one line?
