rearranging a table

D

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

I have tried pivot table but does not work.
Any idea?
Many thanks,
Dan
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

(Repost) new order of table 3
new order of table 5
rearrange data - kind of pivot table 3
Need a list of value no aggregate data 2
Read Matrix via function 2
modified pivot table using a macro 2
how to format rows by groups 1
Setting column width in a table with a macro is not working 0

Top