Suppose your names are in column A and that you have a header row so
that your data starts on row 2. Insert a new column B, and put this
formula in B2:

=IF(B2=B1,"",B2)

Copy this down as far as required. You can then hide column A so that
you have the effect you wanted, but the full names are still there if
required for other formulae (eg producing summaries for each person).

If you really want to you can fix the values in column B and then
delete column A. To fix the values, highlight column B, click <copy,
then Edit | Paste Special | Values (check) | OK then <Esc.

Hope this helps.

Pete

On Oct 3, 11:22*am, Templar wrote:
For the sake of discussion, let's say you have ten entries of the same
person, same address etc on lines 1-10. *You want to eliminate this
redundancy and reduce
this to just one entry of that persons name and address. *Is it possible for
me to
eliminate the other 9 lines and retain just 1 line?

Thank you.
--
Templar