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