pivot table help

[Josie]

I've got a (non-pivot) table with 5 columns that looks like this:

HRG POD yr1data yr2data yr3data

HRG and POD are categories, and the figures in the 3 data columns are the
values of interest. I want to have HRG as the rows, and then I want 3 main
column headings: yr1data, yr2data and yr3data. however, there's only 5
possible values for POD, and I want each of the 3 data columns split into 5
subcolumns, each headed by a value of POD.

I can get the pivot table with HRG as rows and POD as columns, but I only
seem to be able to add the data by subdividing rows rather than columns, even
when choosing 'column area' in the 'add to' drop down.

any suggestions gratefully received

 

[Debra Dalgleish]

In the pivot table, drag the Data button into the column area
In the column area, move the POD button to the left of the Data button

 

[Josie]

if I drag the data column into the column area, it generates columns based on
the values within the column, ie 1.6, 2.35 etc etc

 

[Debra Dalgleish]

There's a picture here, that shows what I mean:

http://www.contextures.com/xlPivot02.html

Does your pivot table have a Data button like the one in the picture?