Narrow format Excel EDD files have multiple analyte results for a location per each row.

Example file:

In Configuration, Source Configuration set as follows:

In WIMS, Variable Setup to get data for Rocky Creek Inf, BOD result: