search for: observation1

...55225,42.52641,181 27.56512,42.52641,177 27.57800,42.52641,181 27.59087,42.52641,181 27.60375,42.52641,180 27.61662,42.52641,181 ..., ..., ... with approximately 1000000 observations for each. All these tables have the same xcoord and ycoord and I would like to get a table of the form XCOORD,YCOORD,OBSERVATION1,OBSERVATION2,... 27.47500,42.52641,177,233,... 27.48788,42.52641,177,345,... 27.50075,42.52641,179,233,... 27.51362,42.52641,178,123,... 27.52650,42.52641,180,178,... 27.53937,42.52641,178,...,... 27.55225,42.52641,181,... 27.56512,42.52641,177,... 27.57800,42.52641,181,... 27.59087,42.52641,181,....