Try this: cbind(x$id, t(do.call(rbind, lapply(x[-1], sapply, switch, '1' = c(1,1), '2' = c(1, 2), '3' = c(2, 2)))))
On Tue, Nov 24, 2009 at 1:51 PM, Lisaj <lisa...@gmail.com> wrote: > > Hello, R users, > > I have a dataset that looks like this: > > id var1 var2 > 1 1 3 > 2 3 1 > 3 2 1 > 4 1 2 > 5 2 3 > > I want to split one column to two columns with 1 = 1 and 1, 2 = 1 and 2, 3 = > 2 and 2: > > id var1.1 var1.2 var2.1 var2.2 > 1 1 1 2 2 > 2 2 2 1 1 > 3 1 2 1 1 > 4 1 1 1 2 > 5 1 2 2 2 > > Can anyone please help how to get this done? Thanks a lot in advance > > Lisa > > -- > View this message in context: > http://old.nabble.com/Split-column-tp26498361p26498361.html > Sent from the R help mailing list archive at Nabble.com. > > ______________________________________________ > 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. > -- Henrique Dallazuanna Curitiba-Paraná-Brasil 25° 25' 40" S 49° 16' 22" O ______________________________________________ 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.