want to turn PT row data into column data

  • Thread starter Thread starter phynkel
  • Start date Start date
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
 
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
 
Back
Top