[R] Transforming data for nice output table

[David Doyle]

Hello everyone,

I'm trying to generate tables of my data out of R for my report.

My data is setup in the format as follows and the example can be found at:
http://doylesdartden.com/R/ExampleData.csv

Location        Date        Year      GW_Elevation
127(I)        5/14/2006     2006       752.46
119(I)        5/14/2006     2006       774.67
127(I)        6/11/2007     2007       752.06
119(I)        6/11/2007     2007       775.57

I would like to generate a table that showed

Location    GW_Elevation 2006    GW_Elevation 2007    GW_Elevation xxx.....

119(I)                    774.67                      775.57
          xxxx
127(I)                    752.46                      752.06
          xxxx
XXXX                          XX                           XX

 Any thoughts on how to transform the data so it would be in this format??

Thank you for your time

David Doyle

	[[alternative HTML version deleted]]