| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
(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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
(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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
(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 |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
(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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| PIVOT TABLE HELP (PLEASE) - REPOST | Excel Discussion (Misc queries) | |||
| (Repost) - Pivot table: Grouping first row field by fifth row fiel | Excel Programming | |||
| Pivot Table Page Field (Repost) | Excel Programming | |||
| Repost: Pivot Table | Excel Discussion (Misc queries) | |||
| Repost - Extracting a table from a cell | Excel Programming | |||
Linear Mode
