Is this close to what you want? > x <- read.table('clipboard')
> x V1 V2 V3 V4 1 xyz 01/03/2007 15.25 USD 2 xyz 01/04/2007 15.32 USD 3 xyz 01/02/2008 23.22 USD 4 abc 01/03/2007 45.20 EUR 5 abc 01/04/2007 45.00 EUR 6 abc 01/02/2008 68.33 EUR > x.m <- melt(x) Using V1, V2, V4 as id variables > x V1 V2 V3 V4 1 xyz 01/03/2007 15.25 USD 2 xyz 01/04/2007 15.32 USD 3 xyz 01/02/2008 23.22 USD 4 abc 01/03/2007 45.20 EUR 5 abc 01/04/2007 45.00 EUR 6 abc 01/02/2008 68.33 EUR > cast(x.m, V2~V4) V2 EUR USD 1 01/02/2008 68.33 23.22 2 01/03/2007 45.20 15.25 3 01/04/2007 45.00 15.32 > On Thu, Mar 20, 2008 at 1:22 AM, Ravi S. Shankar <[EMAIL PROTECTED]> wrote: > Hi R users, > > > > I have a dataframe in the below format > > xyz 01/03/2007 15.25 USD > > xyz 01/04/2007 15.32 USD > > xyz 01/02/2008 23.22 USD > > abc 01/03/2007 45.2 EUR > > abc 01/04/2007 45.00 EUR > > abc 01/02/2008 68.33 EUR > > > > I want to change the above data into the below format > > > > > > xyz 01/03/2007 15.25 USD abc > 01/03/2007 45.2 EUR > > xyz 01/04/2007 15.32 USD abc > 01/04/2007 45.00 EUR > > xyz 01/02/2008 23.22 USD abc > 01/02/2008 68.33 EUR > > > > Any help would be welcome > > > > Thank you > > > > Ravi > > > > > > This e-mail may contain confidential and/or privileged i...{{dropped:13}} > > ______________________________________________ > R-help@r-project.org mailing list > https://stat.ethz.ch/mailman/listinfo/r-help > PLEASE do read the posting guide http://www.R-project.org/posting-guide.html > and provide commented, minimal, self-contained, reproducible code. > -- Jim Holtman Cincinnati, OH +1 513 646 9390 What is the problem you are trying to solve? ______________________________________________ R-help@r-project.org mailing list https://stat.ethz.ch/mailman/listinfo/r-help PLEASE do read the posting guide http://www.R-project.org/posting-guide.html and provide commented, minimal, self-contained, reproducible code.