I suppose that depends upon the purpose of the data. Here are two examples where extra/partially duplicated rows would not be wanted: 1) you’re cleaning an address book (perhaps to send holiday cards) or 2) creating an online email discussion list. In those cases you’d want only one address label to be generated or an email address to be included only once.
Thanks as usual for your thorough responses.