View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Guest3731 Guest3731 is offline
external usenet poster
 
Posts: 4
Default adding blank cells to multiple columns to show similarities

Hi - I am hoping I can make my question clear - I have several columns
of alphabetic data (names). What I would like to do, if possible, is
to line up any and all names that are the same between any two or more
columns by adding blank cells as needed, such that it is possible to
see at a glance which names are common to one or more columns.
Something like:

A B C D

bob bob
carol carol
doug
elbert
fatty fatty

Is this doable in some automated way?

Thanks very much -