Dear anyone who knows more about R than me (so everyone). I have been bashing my head on the keyboard all day trying to do something with my table.
I have some data, like so: yyyy-mm Rainfall(mm) 1 1977-02 17.4 2 1977-03 34.0 3 1977-04 26.2 4 1977-05 42.6 5 1977-06 58.6 6 1977-07 23.2 7 1977-08 26.8 8 1977-09 48.4 9 1977-10 47.0 10 1977-11 37.2 11 1977-12 15.0 12 1978-01 2.6 13 1978-02 6.8 14 1978-03 9.0 15 1978-04 46.6 The data continues on for x number of hundreds of data points. Simply put, I need to make that data.frame into this data.frame/table/matrix/grid/... you get the picture. Jan Feb Mar ... etc Year Rain Rain Rain Year Rain Rain Rain Year Rain Rain Rain Year etc... Year Year How on earth do I do it? I have made little to no progress on it all day. Also, just like all the other problems, the year and month will change every time depending upon which csv file or sql query I load into the program. If anyone has any pointers, that would be awesome. Cheers lads. -- View this message in context: http://n4.nabble.com/Separating-columns-and-sorting-by-rows-tp1555806p1555806.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.