Reply to thread

Message: [QUOTE="JeffC, post: 3258236"] Hi, I have a pivot table with payroll information. Right now weeks go across the top (column headings), and employees down the left (row headings). In the data area, I have two fields: sum of hours, and sum of gross pay. These two fields are being grouped in columns (i.e., each week now spans two columns... one for hours, one for pay.) I want to change the layout such that the two data items become two rows (i.e., each employee now spans two rows, one for hours, one for gross pay - but only one column for each week). In previous versions of excel I remember being able to do this... but I haven't worked with pivot tables in a while and I now have Excel 2007. Thanks in advance and I hope my description is clear enough. (Windows XP, Excel 2007) [/QUOTE]