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.