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

Nick,

Create your pivot table, then grab the data button, and drag it to just underneath the column
headers. When you get a 'ghost' insertion cursor, let go of your mouse button...

HTH,
Bernie
MS Excel MVP


"Nick" wrote in message
...
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

Bernie

just done it....worked a treat!

that had bugged me for years!

Thanks a lot!

Nick

"Bernie Deitrick" wrote:

Nick,

Create your pivot table, then grab the data button, and drag it to just underneath the column
headers. When you get a 'ghost' insertion cursor, let go of your mouse button...

HTH,
Bernie
MS Excel MVP


"Nick" wrote in message
...
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