Hi
We set up a basic sheet at work to collect data from around 400 sources using a form submission.
We have used this many times without any issue but this time the first 60+ submissions /rows are fine, the next 19 seem fine other than 6 columns, not together have exactly the same text in (word for word) from unrelated sources - all other columns are obviously different as expected. There are even a couple of columns in the middle of the duplicated ones that are different on each row to add to confusion.
First instinct was someone had dragged down in error, second was the submissions were copying in pasting from somewhere but neither of these really work.
The audit log on shows changes when a colleagues exported to excel this morning but the changes show from and to as exactly the same text.
3 later submissions are all unique throughout the row.
I've tried snapshots of previous versions but it shows the day before as the 60+ unique rows to the next one with 19 rows with some identical information.
Absolutely baffled so just asking if anyone has any ideas, is this somehow a glitch or coincidence that the 19 adjacent rows copied data and pasted into the form
Thanks
Barry