want to turn PT row data into column data

P

phynkel

original data:

name win loss score
paul 1 325
Jane 0 1 225
walt 1 400
nancy 0 200
jane 1 300
nancy 1 200
paul 1 365
walt 1 350


when i create p.t. I get (or a vague approximation)

paul
win 2
loss 0
avg 345

jane
win 1
loss 1
avg 260

walt
win 1
loss 1
avg 375

nancy
win 0
loss 2
avg 200







but this is what I would like:



name win loss avg

Paul 2 0 345

Jane 1 1 260

walt 1 1 375

nancy 0 2 200
----------------------------


HOw?

tx
 
B

Bernie Deitrick

phynkel,

Grab the gray data button, click and drag it to the column heading that says
"Total". Then you should get your desired arrangement.

HTH,
Bernie
MS Excel MVP
 
Top