Groundwater analytical data over time best practice

BenjaminLockwood
BenjaminLockwood Posts: 1
edited October 14 in Leapfrog

Does anyone have a best practice for how to import groundwater data that was collected over many sampling events (10+)? I am running into "Overlapping intervals" errors since I am importing all of groundwater analytical data from several events in the same table. I've included a example table of the format I am using to import analytical data.

Seems like the only way to do it "right" is by importing each sample event as a separate table, but with data from every 4 quarters for the last 10 years, that is a lot of data to import and visualize. I feel like there should be a way to which between event using a category column or a query.