(Repost) new order of table
 

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

(Repost) new order of table
 

Use a pivot table?

"Dan" wrote:

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

(Repost) new order of table
 

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" wrote:

Use a pivot table?

"Dan" wrote:

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

(Repost) new order of table
 

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,


"Dan" wrote:

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" wrote:

Use a pivot table?

"Dan" wrote:

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