(Repost) 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

 

[Sam Wilson]

Use a pivot table?

 

[Dan]

Pivot table give me a count or a sum not a list of data - it can give me a
list of data for one intersection at a time for not for all the table.
Thanks.
Dan

 

[Sam Wilson]

In that case you'll have to write a macro with two loops - the first loop to
make an array of unique names from column A, the second to do the same from
column B. Then deploy these to the grid, and create a third loop which goes
through Colun C and adds the text to the relevant cell in this grid,