I apologize for such short question. Hopefully, I explain better what I am looking for below.
Here is how my dataset currently looks like:
"column 1" "column 2"
Location A goods1
Location A goods2
Location A goods3
Location B goods2
Location B goods3
Location B goods4
Location B goods6
I would like to have only one row for each location so the data would look like the following:
Location A goods1/goods2/goods3
Location B goods2/goods3/goods4/goods6
Any suggestion would be welcome. Thanks a lot again.
Arina
---- Original message ----
>Date: Tue, 2 Dec 2008 18:09:09 +0100
>From: [email protected] (on behalf of "Martin Weiss" <[email protected]>)
>Subject: st: RE: converting many rows into one
>To: <[email protected]>
>
>Line for the server...
>
>Remember the FAQ, 3.2:
>
>"Many questions do not get answered because they are too short". Why do you
>want to convert your data into a single row? It is hard to think of a
>practical use for such a procedure...
>
>HTH
>Martin
>
>
>-----Original Message-----
>From: [email protected]
>[mailto:[email protected]] On Behalf Of Arina Viseth
>Sent: Tuesday, December 02, 2008 6:06 PM
>To: [email protected]
>Subject: st: converting many rows into one
>
>Dear Stata users,
>
>I am trying to convert many rows into one row.
>Any idea of how I could do it?
>
>Thanks a lot in advance.
>
>Arina
>*
>* 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/
>
>*
>* 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/
*
* 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/
