Is there a way to group many rows into one row based on matching values of selected fields?
Hi - I have a large dataset with individual contaminant compound results per row. I.e. Each row has a lat, long, datetime, and a result for one of many compounds. Instead, I need one row, and only one row, for each instance of lat, long, and datetime....that single row would then have ALL compound results on a single row. In other words, I need to group by three fields (lat, long, datetime) an...