Question: The block of data below contains records of water elevation at different location numbers for specific dates. Some of the data records contain one than 1 date. For all of the records that have duplicated dates, average the values to create one record. Create a new set of data that has unique dates for each location. There should be no gaps. One approach is to create a value that is unique for each site and date.
| Location |
Date |
Value |
| 178 |
1/1/2010 |
22.79 |
| 178 |
1/2/2010 |
22.79 |
| 178 |
1/3/2010 |
22.81 |
| 178 |
1/4/2010 |
22.82 |
| 178 |
1/5/2010 |
22.82 |
| 178 |
1/6/2010 |
22.71 |
| 178 |
1/7/2010 |
22.645 |
| 178 |
1/8/2010 |
22.645 |
| 178 |
1/9/2010 |
22.675 |
| 178 |
1/10/2010 |
22.64 |
| 178 |
1/11/2010 |
22.58 |
| 178 |
1/12/2010 |
22.56 |
| 178 |
1/13/2010 |
22.595 |