Wide 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 PWTP EFFLUENT, CBOD result: