Pivot table data layout - columns to rows

J

JeffC

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)
 
J

JeffC

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top