Pivot table data layout - columns to rows
 

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)

Pivot table data layout - columns to rows
 

Never mind... I just figured it out. You drag the "Values" block from the
column to the row area in that side panel... thanks.

"JeffC" wrote:

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)