new order of table

[Dan]

Is there a way to rearange a table with 3 columns
from:

Class Topic Name
A English Marc
B Math Dan
C Math Lisa
A English Jhon
A Math Dave
B History Ling

To:

English Math History
A Marc Dave
Jhon
B Dan Ling
C Lisa


Any idea?
Many thanks,
Dan

 

[Jacob Skaria]

Menu Data-->PivotTable. Next->Next->Next
Drop Class to Row field
Drop Topic to Column field
Drop Name to Data field
Right click on the count and show detail.

Please let us know if you are expecting a macro to do this...

If this post helps click Yes

 

[Dan]

Thank you but what do you mean:
"Right click on the count and show detail."
if I right click on the "Count Name" I do not have this option.
If I right click on any of the counted cells then I do have the option but
if gives me a new table only for that count, I need to see all the data in
one table.
(I have excel 2003)

 

[Dan]

If you have a macro, maybe that will solve my problem. Many thanks.

 

[ryguy7272]

Follow Jacob' instructions. Then go to the lower right of the Pivot Table.
Select that cell and hold the mouse button down as you move to the upper left
of the Pivot Table. Then, right-click anywhere in the 'Value' fields, which
includes the intersection of Topic and Class. That should do it for you.

I don't want to give you code because I am at school now, and all they have
here is Excel 2007. I don't think it will work for you on 2003. Maybe, but
certainly no guarantee. Try the steps I described above and let us know how
you get on with it.


Regards,
Ryan---

 

[Dan]

Thank you but did not work on 2003, it just gave me back the source of my
pivot table, and if I click just on one cell it give me the source for just
that cell.

If you can give me a macr would be great.
Thanks,
Dan