Dear R helpers
 
After executing the R code, where the last few lines of the code are something like given below.
 
 
## Part of my R code
 
 
n = 20
 
........
.........
 
final_output = data.frame(Numbers = numbers, ABC = data1, XYZ = data2, PQR = data3)
          
write.csv(data.frame(Scenario = paste("Sc_", 1:n, sep = ""), final_output'), 'result.csv', row.names = FALSE)          

## End of code
 
 
When I open the 'result.csv' file, my output is like
 
Scenario     Numbers         ABC                 XYZ                 PQR
Sc_1                1                  22                  18                     6
Sc_2                2                  24                  16.5                 11
SC_3               3                  38                    41                  38 
 
................................................................
 
Sc_20            20                  15                 27.5                  74
 
 
## MY REQUIEMENT
 
I wish to have output like given below.
 
Scenario             Numbers       Names      Values                  
 
Sc_1                        1             ABC         22
Sc_1                        1             XYZ          18
Sc_1                        1             PQR           6   
Sc_2                        2             ABC          24
Sc_2                        2             XYZ          16.5
Sc_2                        2             PQR           11
 
.................................................................
 
 
Sc_20                     20           ABC           15
Sc_20                     20           XYZ            27.5
Sc_20                     20           PQR           74     
 
 
Please guide how this can be achieved?
 
Regards and thanks in advance
 
Amelia
 
 
 
 
          


      
	[[alternative HTML version deleted]]

