Example data

Product Date Volume Value

Product A 25/11/05 10 200
Product B 25/11/05 15 240
Product C 25/11/05 12 130
Product A 25/11/05 18 260
Product A 26/11/05 12 130
Product B 26/11/05 19 240

I want a pivot table that looks like this:

I have to do 2 separate pivot tables and merge then together.

Product A Product A Product B Product B Product C Product C
Date Volume Value Volume Value Volume Value

25/11/05 28 460 15 240 12 130
26/11/05 12 130 19 240

I want to the pivot table to show, so that Volume and Value for each PRODUCT
are in COLUMNS side by side.

If a create a pivot table with the wizard

· move Product in €˜Column fields
· move date to €˜row fields
· move volume and value in €˜data items


At the moment Excel, puts the VOLUME and VALUE in separate ROWS in the same
column, like below:

Product A Product B Product C
Date

25/11/05 Vol 28 Vol 15 Vol 12
Val 460 Val 240 Val 130

26/11/05 Vol 12 Vol 19
Val 130 Val 240

Anyone got any ideas???

Thanks