I am currently working on a project that contains data on criminals. The tables I am working with list each defendant once for every crime or violation they commit. For example the table looks something like this:
Doe, John...DWI
Doe, John...grand theft auto
Doe, John...petit larceny
Because...