| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to create crosstabs in a table?????
Hi,
Originally, I have the table of data organized in the format as below:- Discipline Title Status Year Amount Core Mekong D Rejected 2006 1600 1800 Mekong D Rejected 2008 2000 2500 Mekong F Rejected 2008 2600 3000 Mekong E Under Dev. 2007 3000 3200 Mekong E Under Dev. 2008 2000 2000 Pacific C Expected 2008 2000 2100 Pacific C Expected 2009 2000 2500 Pacific A Secured 2006 1000 1200 Pacific A Secured 2007 1800 2000 Pacific B Under Dev. 2007 3000 3200 But I would like the table to be re-format into the layout as below:- Discipline Title Status 2006 2007 2008 2009 Mekong D Rejected 1600 1800 2000 2500 Mekong F Rejected 2600 3000 Mekong E Under Dev. 3000 3200 2000 2000 Pacific C Expected 2000 2100 2000 2500 Pacific A Secured 1000 1200 1800 2000 Pacific B Under Dev. 3000 3200 How would I have to convert the table format as the above one???? Do I need an array statement to do so??? By the time being, I still couldn't find a way out but I had tried out using the array; unfortunately, thing still doesn't work out as intented!!! Help and advice needed here.......... Thanking in advance!!! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Crosstabs do not copy as I would like when copying worksheets | Excel Discussion (Misc queries) | |||
| crosstabs | Excel Discussion (Misc queries) | |||
| Create new excel table with filtered records from another table | Excel Worksheet Functions | |||
| need pivot tables to look more like crosstabs with repeating data. | Excel Discussion (Misc queries) | |||
| create a source table from a special pasted value dynamic crossed table | Excel Programming | |||
Threaded Mode
