Try this: x <- read.table(textConnection("\"1989-90\",\"1990-91\" Barley,23,34 Oats,15,16"), sep = ",", header = T, check.names = FALSE)
t(x) or if you want year as column and not rownames: data.frame(Year = names(x), t(unname(x))) On Wed, Apr 16, 2008 at 7:27 AM, Geoff Russell <[EMAIL PROTECTED]> wrote: > Hi use Rs, > > I have a csv file: > > "1989-90","1990-91" > Barley,23,34 > Oats,15,16 > > Which I want to turn into: > year, Barley, Oats > 1 "1989-90", 23, 15 > 2 "1990-91",34,16 > > Transpose doesn't quite do it, is there a standard way? > > Cheers, > > Geoff Russell > > ______________________________________________ > 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 [[alternative HTML version deleted]]
______________________________________________ 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.