Hi,

I am trying to reshape my data. Stata says that the data is currently wide. The current data is:

Code:
* Example generated by -dataex-. To install: ssc install dataex
clear
input str10 id str8 var double(q1 q2 q3 q4)
"U681977104" "MV"   115.49000000000001             113.88 116.22            179.04
"U681977104" "MTBV"               7.79               6.09   6.21              9.57
"U68231A204" "MV"                 3.42               5.07   5.51 7.890000000000001
"U68231A204" "MTBV"               1.28 1.9000000000000001   2.07              2.96
"U68243Q106" "MV"                    .                  .      .            287.89
"U68243Q106" "MTBV"                  .                  .      .              4.42
end
Now, I would like to reshape the data as follows:


Code:
* Example generated by -dataex-. To install: ssc install dataex
clear
input str10 id str2 q float MV double MTBV
"U681977104" "q1" 115.49               7.79
"U681977104" "q2" 113.88               6.09
"U681977104" "q3" 116.22               6.21
"U681977104" "q4" 179.04               9.57
"U68231A204" "q1"   3.42               1.28
"U68231A204" "q2"   5.07 1.9000000000000001
"U68231A204" "q3"   5.51               2.07
"U68231A204" "q4"   7.89               2.96
"U68243Q106" "q1"      .                  .
"U68243Q106" "q2"      .                  .
"U68243Q106" "q3"      .                  .
"U68243Q106" "q4" 287.89               4.42
end
Since I have a large data set, I would like to use "reshape."
Any helps would be greatly appreciated.

Thanks a lot.