Hi,

My data contains multiple observations for the variable Dealsubtype, whereas I want to change the layout to be dealsubtype 1, dealsubtype 2, dealsubtype 3, etc..

Is there an easy way to transpose the data in variable Dealsubtype so that instead of different rows, the different subtypes are in the columns?

Thanks in advance!


Code:
* Example generated by -dataex-. To install: ssc install dataex
clear
input str5 A str65 Acquirorname str30 Dealsubtype
"1."  "PETSMART INC."                          "Exit"                 
""    ""                                       "Buy & Build"          
""    ""                                       "Leveraged buy out"    
"2."  "ADVENT INTERNATIONAL CORPORATION"       "Buy & Build"          
""    ""                                       ""                     
"3."  "BWAY CORPORATION"                       "Leveraged buy out"    
""    ""                                       "Secondary buy-out"    
""    ""                                       "Buy & Build"          
""    ""                                       "Exit"                 
"4."  "DTZ INVESTMENT HOLDINGS LP"             "Buy & Build"          
""    ""                                       ""                     
""    ""                                       ""                     
""    ""                                       ""                     
""    ""                                       ""                     
""    ""                                       ""                     
""    ""                                       ""                     
""    ""                                       ""                     
"5."  "CINVEN LTD"                             "Secondary buy-out"    
""    ""                                       "Exit"                 
""    ""                                       "Buy & Build"          
""    ""                                       ""                     
""    ""                                       ""                     
""    ""                                       ""                     
"6."  "GFKL FINANCIAL SERVICES AG"             "Exit"                 
""    ""                                       "Buy & Build"          
""    ""                                       ""                     
""    ""                                       ""                     
""    ""                                       ""                     
""    ""                                       ""                     
"7."  "BRAMMER FRANCE SAS"                     "Exit"                 
""    ""                                       "Buy & Build"          
""    ""                                       ""                     
""    ""                                       ""                     
""    ""                                       ""                     
""    ""                                       ""                     
""    ""                                       ""                     
""    ""                                       ""                     
"8."  "AVAST SOFTWARE BV"                      "Exit"                 
""    ""                                       "Public takeover"      
""    ""                                       "Patent sale"          
""    ""                                       "Buy & Build"          
""    ""                                       "Recommended bid"      
"9."  "VEDICI GROUPE SAS"                      "Exit"                 
""    ""                                       "Buy & Build"          
""    ""                                       ""                     
""    ""                                       ""                     
"10." "PANASONIC HEALTHCARE HOLDINGS CO., LTD" "Buy & Build"          
""    ""                                       ""                     
"11." "WAYPOINT GROUP HOLDINGS LTD"            "Buy & Build"          
""    ""                                       "Exit"                 
""    ""                                       ""                     
""    ""                                       ""                     
""    ""                                       ""                     
"12." "MAGYAR TELECOM BV"                      "Exit"                 
""    ""                                       "Buy & Build"          
""    ""                                       ""                     
"13." "IDCSALUD SL"                            "Exit"                 
""    ""                                       "Buy & Build"          
"14." "PUBLIC SECTOR PENSION INVESTMENT BOARD" "Patent sale"          
""    ""                                       "Buy & Build"          
""    ""                                       ""                     
""    ""                                       ""                     
"15." "REICHHOLD LLC 2"                        "Exit"                 
""    ""                                       "Buy & Build"          
""    ""                                       "Patent sale"          
"16." "ALLNEX BELGIUM SA/NV"                   "Recommended bid"      
""    ""                                       "Buy & Build"          
""    ""                                       "Patent sale"          
""    ""                                       "Public takeover"      
""    ""                                       "Scheme of arrangement"
""    ""                                       ""                     
""    ""                                       ""                     
""    ""                                       ""                     
""    ""                                       ""                     
""    ""                                       ""                     
"17." "MANAGEMENT"                             "Buy & Build"          
""    ""                                       "Exit"                 
""    ""                                       ""                     
""    ""                                       ""                     
""    ""                                       ""                     
""    ""                                       ""                     
"18." "ENCAPSYS LLC"                           "Buy & Build"          
""    ""                                       "Patent sale"          
""    ""                                       "Exit"                 
""    ""                                       "Secondary buy-out"    
"19." "BRIDGEPOINT CAPITAL LTD"                "Leveraged buy out"    
""    ""                                       "Buy & Build"          
""    ""                                       "Exit"                 
""    ""                                       "Secondary buy-out"    
""    ""                                       ""                     
""    ""                                       ""                     
""    ""                                       ""                     
""    ""                                       ""                     
""    ""                                       ""                     
""    ""                                       ""                     
"20." "KLOCKNER PENTAPLAST GMBH"               "Patent sale"          
""    ""                                       "Exit"                 
""    ""                                       "Buy & Build"          
""    ""                                       ""                     
""    ""                                       ""                     
end