Dear Statalist,
I am using Stata/SE 11 for Windows  to try to change the place of
observations in editor.
From
group1	result1	group2	result2
1	1	0	0
1	0	0	1
1	1	0	0
1	0	0	1
1	1	0	0
To
group	result
1	1
1	0
1	1
1	0
1	1
0	0
0	1
0	0
0	1
0	0
I wrote a do file to conduct this change as below.
-----------------------------------------------
clear
foreach var in ///
	group1 result1 group2 result2 {
gen `var'=.
}
set obs 5
replace group1=1
replace group2=0
replace result1=1 in 1
replace result1=0 in 2
replace result1=1 in 3
replace result1=0 in 4
replace result1=1 in 5
replace result2=0 in 1
replace result2=1 in 2
replace result2=0 in 3
replace result2=1 in 4
replace result2=0 in 5
preserve
	drop group2 result2
	rename group1 group
	rename result1 result
	save groupresult.dta,replace
restore
drop group1 result1
	rename group2 group
	rename result2 result
append using groupresult.dta
--------------------------------------------------
But I would like to know how can I do it more simple way, without making
dta.file.
Can someone help me with this?
Regards,
Ichiro
*
*   For searches and help try:
*   http://www.stata.com/help.cgi?search
*   http://www.stata.com/support/statalist/faq
*   http://www.ats.ucla.edu/stat/stata/