multiple value in row

[Selvad71]

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.

 

[Selvad71]

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.