Lookup field is great to consolidate the data from all the linked records into the parent Table cell.
But there can be a way to avoid duplicates while consolidating.
On Child Table, I have Collaborator assigned to each Row. But that same Collaborator can be on many rows.
On parent Table, it shows all the occurrence of that collaborator multiple times which is also great, but there can be an option to Merge Duplicates so it shows only Unique Entries.