Transpose data

Giganews Newsgroups
Subject: Transpose data
Posted by:  Mike
Date: Thu, 25 May 2006

Is there way in Excel I can transpose the data show her in "Original"  to
"Required" format [the alignment of data did not copy exactly].
In the Required format the Original column names are changed to code numbers

Original Format                        
Emp No    Date    Charge    Rent    Service    Furniture    
005083    14/07/2006    88    71    0    17    
000086    16/07/2006    107    107    0    0    
000093    15/07/2006    193    176    0    17    
005715    14/07/2006    222    222    0    0    
008957    16/07/2006    300    300    0    0    

Required Format        Code    7154    7155    7156    7157
Emp No    Date    Code    Charge    Rent    Service    Furniture
005083    14/07/2006    7154    88            
005083    14/07/2006    7155        71        
005083    14/07/2006    7156            0    
005083    14/07/2006    7157                17
000086    16/07/2006    7154    107            
000086    16/07/2006    7155        107        
000086    16/07/2006    7156            0    
000086    16/07/2006    7157                0
000093    15/07/2006    7154    193            
000093    15/07/2006    7155        176        
000093    15/07/2006    7156            0    
000093    15/07/2006    7157                17

Thanks

Mike

Replies