st: Corrected Creating multiple observations from mixed observation?

["Greenland, Andrew N" <agreenla@purdue.edu>]

I need to insert a new observation into the dataset I am working on.
Multiple row's from a spreadsheet have been read into the same column and I need to separate them and insert them into the dataset.

The data should Look as follows:
var1        var2        var3
NAME1    Price1      Price2
NAME2    Price3      Price4

Instead they look take on a pattern like this:
var1                        var2                     var3
NAME1NAME2                Price1Price3               Price2Price4

Thanks a ton in advance.

Andrew

*
*   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/