Hi, i have a table like this

name year value1 value2
xxxx 2000 1 2
xxxx 2001 2 1
xxxx 2002 2 2
yyyy 2000 3 0
yyyy 2002 2 2

when i pivot i have this result:
2000
2001 2002
sum of value1 sum of value2 sum of value1 sum of
value2 sum of value1 sum of value2
xxxx 1 2
2 1 2 2
yyyy 3
0
2 2

but i'd like to have the multiple value in row not in column:
2000 2001 2002
xxxx sum of value1 1 2 2
sum of value2 2 1 2
yyyy sum of value1 3 2
sum of value2 0 2

Is it possible?

thanks.

Right click on the pivot table

click on wizard | click layout | column header drag the year(check it
right side) & for row header drag the name | for data part drag the
value 1 & value 2 | ok | finish


On Sep 11, 6:57*am, Selvad71 wrote:

Hi, i have a table like this

name year value1 value2
xxxx * 2000 * 1 * * * *2
xxxx * 2001 * 2 * * * *1
xxxx * 2002 * 2 * * * *2
yyyy * 2000 * 3 * * * *0
yyyy * 2002 * 2 * * * *2

when i pivot i have this result:
* * * * * * * * * * * * 2000
2001 * * * * * * * * * * * * * * * * * * 2002
* * * * sum of value1 *sum of value2 * *sum of value1 *sum of
value2 * * sum of value1 *sum of value2
xxxx * * * * * 1 * * * * * * * * * *2
2 * * * * * * * * * *1 * * * * * * * * * * * * * * *2 * * * * * * * 2
yyyy * * * * * *3
0
2 * * * * * * * 2

but i'd like to have the multiple value in row not in column:
* * * * * * * * * * * * * * * * *2000 * * * * *2001 * * * * 2002
xxxx * sum of value1 * * *1 * * * * * * * *2 * * * * * * *2
* * * * * sum of value2 * * * 2 * * * * * * * 1 * * * * * * *2
yyyy * sum of value1 * * *3 * * * * * * * * * * * * * * * 2
* * * * * sum of value2 * * *0 * * * * * * * * * * * * * * 2

Is it possible?

thanks.

I have excel 2007, i do not find wizard if i right click. But i have a
similar window for layout.
If i drag field in row header, column header and value i have this
result:

column header
value1 value2
row header

i want this result:
column header
row header value1
value2

I try to explain better: i have a lot of value filed. I want a row for
every value filed. Dragging the value filed i obtain a column for each
value fields

Thanks.



On 11 Set, 13:16, muddan madhu wrote:
Right click on the pivot table

click on wizard | click layout | column header drag the year(check it
right side) & for row header drag the name | for data part drag the
value 1 & value 2 | ok | finish