I have a problem with reshaping, I don't know how to do this. Can someone help please?
I have this:
obs_no vname place v_ Var2
250 "term1" "rancho mirage" 1996 . "A199601817" . . . . . .
250 "term2" "rancho mirage" 1997 . "A199601817" . . . . . .
250 "term3" "rancho mirage" 1998 . "A199601817" . . . . . .
250 "term4" "rancho mirage" 1999 . "A199601817" . . . . . .
251 "term1" "rancho mirage" 1994 . "A199601815" . . . . . .
251 "term2" "rancho mirage" 1995 . "A199601815" . . . . . .
251 "term3" "rancho mirage" 1996 . "A199601815" . . . . . .
251 "term4" "rancho mirage" 1997 . "A199601815" . . . . . .
252 "term1" "riverside" 1996 . "A199601819" . . . . . .
252 "term2" "riverside" 1997 . "A199601819" . . . . . .
252 "term3" "riverside" 1998 . "A199601819" . . . . . .
252 "term4" "riverside" 1999 . "A199601819" . . . . . .
253 "term1" "riverside" 1999 . "A199601821" . . . . . .
253 "term2" "riverside" 2000 . "A199601821" . . . . . .
253 "term3" "riverside" 2001 . "A199601821" . . . . . .
253 "term4" "riverside" 2002. "A199601821" . . . . . .


I want this:
place A199601817 A199601815 A199601819 A199601821
"rancho mirage" 1996 1994
"rancho mirage" 1997 1995
"rancho mirage" 1998 1996
"rancho mirage" 1999 1997
"riverside" 1996 1999
"riverside" 1997 2000
"riverside" 1998 2001
"riverside" 1999 2002