I have a list of names and addresses but if two people live at the same
address they are listed separately. Is there a way to combine cells in which
the cell to right is the same.

example: [ John Smith] [123 Maple Ln]
[ Jane Smith] [123 Maple Ln]

becomes: [John Smith [123 Maple Ln]
Jane Smith ]

any help would be greatly apprecitated.