[Help-glpk] Transposing result table using MathProg

[Noli Sicad]

Hi,

I have dealing a lot of manual format of my LP result inorder that I
can use the data for the map purpose. I did to run my LP results into
graphs and maps. I am working on forest management / forest carbon
estate modelling and maps are very important to visualise multi period
results of the LP model. The period that I am running is 1 to 100
years.

This is the LP format as output by MathProg.

From:
set A set B set C param


Desired table,
To:
set A set B param set C


Sample result and desired table (below)

How do I do in MathProg? As we know there is transpose (tr.) in Data
section. I hope this can be use in the result sectio as well. But
probably somebody can show me how to do this in MathProg / GMPL.

Thanks. Noli



~~~~~~~~
CROP_ID CROPTYPE        Period  Ini_Age Area_Cut
83      SORI    1       31      528.2465512
84      SORI    1       32      74.55179899
85      SORI    1       33      72.45778618
86      SORI    1       34      139.5272947
82      SORI    2       28      1.711642933
83      SORI    2       29      2.500000071
84      SORI    2       30      432.5139327
93      SORM    2       35      316.8422545
62      OTRM    3       30      64.60526438
82      SORI    3       27      26.93674606
3       SORM    3       35      223.3658345
82      SORI    4       26      2.500000071
4       SORM    4       34      1008.643
5       OTRI    5       25      32.42603214
5       OTRM    5       29      65.9031344
5       SORM    5       32      223.1489321
5       SORM    5       33      72.59203041
5       SORM    5       35      222.8402746
6       OTRI    6       22      2.499999851
6       OTRI    6       23      3.374626509
6       OTRI    6       24      96.13462257
6       OTRM    6       26      830.7463641
6       OTRM    6       27      731.6228643
6       OTRM    6       28      16.3519762
7       OTRM    7       26      1636.5693
8       OTRM    8       26      553.0050146
9       OTRM    9       26      894.414033
10      OTRM    10      24      38.72597099
10      OTRM    10      25      308.6452707
10      OTRM    10      26      786.1761969
10      SORM    10      31      235.8360136

Desired Table.
                Period 1        Period 2        Period 3        Period 4        
Period 5        Period 6        Period
7       Period 8        Period 9        Period 10
CROP_ID CROPTYPE                                                                
                
83      SORI    31                                                              
        
84      SORI    32                                                              
        
85      SORI    33                                                              
        
86      SORI    34                                                              
        
82      SORI            28                                                      
        
83      SORI            29                                                      
        
84      SORI            30                                                      
        
93      SORM            35                                                      
        
62      OTRM                    30                                              
        
82      SORI                    27                                              
        
3       SORM                    35                                              
        
82      SORI                            26                                      
4       SORM                            34                                      
5       OTRI                                    25                              
5       OTRM                                    29                              
5       SORM                                    32                              
5       SORM                                    33                              
5       SORM                                    35                              
6       OTRI                                            22                      
6       OTRI                                            23                      
6       OTRI                                            24                      
6       OTRM                                            26                      
6       OTRM                                            27                      
6       OTRM                                            28                      
7       OTRM                                                    26              
8       OTRM                                                            26      
9       OTRM                                                                    
26
10      OTRM                                                                    
        24
10      OTRM                                                                    
        25
10      OTRM                                                                    
        26
10      SORM                                                                    
        31