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

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 wrote:
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
Contextures
http://www.contextures.com/tiptech.html

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" wrote:

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 wrote:
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
Contextures
http://www.contextures.com/tiptech.html

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?

Josie wrote:
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" wrote:


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 wrote:

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
Contextures
http://www.contextures.com/tiptech.html





--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html