Here you go.
Code:
replace PHONETYPE = "ZZZ" if PHONETYPE=="" sort CASENUM (PHONETYPE) bys CASENUM: g id_n = _n egen cid = group(CASENUM) reshape wide PHONETYPE PHONENUMBER, i(cid) j(id_n) order CASENUM, before(cid) forv i = 2/4 { replace PHONETYPE`i' = "" if PHONETYPE`i'!="Cell" replace PHONENUMBER`i' = . if PHONETYPE`i'!="Cell" }
Comment