Pivot tables - arranging data to appear in columns for each row it

[Guest]

I'm recreating a timesheet using a pivot table. the row data is the employee
name. there is no column. the data item is total hours for a given week
(signified in the data set by the week-ending date.

I want the data to display in columns moving away from the employee name,
like this: "Smith 40 35 39 38"

The Excel default, however, is to show each data item in a row, beginning
with the cell next to the row item (ie, employee name) and then moving down,
so that in the above-example, Smith's 40 hours appear in the cell to the
right of his name, then the following week's 35 hours appear in the cell
directly below the 40, and the following week's 39 below the 35, etc.

I managed to get the table to fill in the data the way I wanted to once, but
I don't know how i did it and I can't replicate it in subsequent tables.

Thanks in advance for any help.

 

[Guest]

Okay, so you have 3 fields (Name, Weekd End Date, and Total Hours) right?

Open up the pivot table wizard and go to the layout screen.
Make Name the Row field.
Make Week End Date the column field.
Make Total Hours the data field.
Click finish
This should give you one row for each name with the week ending total hours
going to the right for as many columns as there are week ending dates.

Sometimes if you have more than one field in the Data section of a pivot
table the items appear below each other, rather than to the right of each
other. What you need to do in that case is (on the completed pivot table)
drag the field labeled "Data" to somewhere in the column section. Then all
the data will go across the screen rather than down. That doesn't apply in
the scenario you just described though because you only have one data field
(Total Hours).

Hope this is a start.

Bill