I wonder if anyone has come across this problem and can shed light on why this is happening and ways to prevent it -

I've been importing plant records in excel format. The records are from the same location, date, recorder so essentially each row only differs in the species name.  The import goes ahead but frustratingly for each observation a new event and sample is created. So instead of one event opening up to one sample containing 200 or so species observations I've got 200 or so events each with a single species in!

Essentially none of these records are wrong, but it looks a bit odd and we like to keep things neat and tidy and not requiring explanation.

Any insight appreciated,

Alex
Lothian Wildlife Infromation Centre