Is there a way of doing this that puts the count of how many lines are duplicates next to the first entry and removes the rest? i.e. 11 lines of duplicate cameras reduced to one line with the number 11 next to it.
Or is there a way to do this in Access before exporting to Excel?