Reshape longer question

[Maroun Mezher]

Hello Stata Forum,

I know I have asked this question before but I am really struggling with my reshape function. My data currently looks like this:

MMA_WTP	LRM_WTP	Combined_WTP	MMA_ct	LRM_ct	Combined_ct
16	20	36	100	250	350

I am looking to have my data look like the following:

Name	WTP	ct
MMA	16	100
LRM	20	250
Combined	36	350

Thank you very much!

[Nick Cox]

clear 
input MMA_WTP    LRM_WTP    Combined_WTP    MMA_ct    LRM_ct    Combined_ct
16    20    36    100    250    350
end 

gen long Id = _n

reshape long @_WTP @_ct , i(Id) j(Name) string 

rename _* * 

list 

     +---------------------------+
     | Id       Name   WTP    ct |
     |---------------------------|
  1. |  1   Combined    36   350 |
  2. |  1        LRM    20   250 |
  3. |  1        MMA    16   100 |
     +---------------------------+

[Maroun Mezher]

Mr Cox, you are a legend. Thank you