Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Pivot tables - arranging data to appear in columns for each row it
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. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Pivot tables - arranging data to appear in columns for each row it
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 "Rob" wrote: 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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
arranging columns in pivot table | Excel Discussion (Misc queries) | |||
Pivot Tables - # of Columns | Excel Discussion (Misc queries) | |||
pivot tables-drop data in, how to make it show as columns instead | Excel Discussion (Misc queries) | |||
ARRANGING DATA IN PIVOT TABLES | Excel Worksheet Functions | |||
Putting data into pivot tables in columns not rows. | Excel Discussion (Misc queries) |