First post after searching this forum and multiple others.
My question is: How do I split data based on the Name Field (ID) to allow charting (scatterplot) each water level vs date. Ideally in an automated way so i don't have to sort data, copy and paste every time someone enters a value.
I want to retain the layout of the existing Table its easy format for data entry.
The order the data is entered is not controlled.
I have several years of data with an example of the layout below.
I'm using Office365 however the dynamic formulas are not available due to license restrictions by my employer.
Any help would be greatly appreciated.
My question is: How do I split data based on the Name Field (ID) to allow charting (scatterplot) each water level vs date. Ideally in an automated way so i don't have to sort data, copy and paste every time someone enters a value.
I want to retain the layout of the existing Table its easy format for data entry.
The order the data is entered is not controlled.
I have several years of data with an example of the layout below.
I'm using Office365 however the dynamic formulas are not available due to license restrictions by my employer.
Any help would be greatly appreciated.
| Easting | Northing | Water level (mAHD) | Name | Date | Volume (uses an array formula to calculate) |
| 5 | Hole 10 | 25/08/2020 | 500 | ||
| 33.5 | DSS | 25/08/2020 | 300 | ||
| 1 | F3N | 25/08/2020 | 10000 | ||
| 5.23 | Hole 10 | 30/08/2020 | 505 | ||
| 1.15 | F3N | 30/08/2020 | 10020 | ||
| 15 | ALE | 30/08/2020 | 573 | ||
| 1.1 | F3N | 01/09/2020 | 10010 | ||
| 33.5 | DSS | 01/09/2020 | 300 | ||
| 5.24 | Hole 10 | 01/09/2020 | 506 |
