View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Kent E. Kent E. is offline
external usenet poster
 
Posts: 1
Default How do I suppress repeating data in Excel

I am importing data into Excel and there are many rows where the first column
repeats 3-4 times. For example, the first column lists a patient name,
while the other columns list different payors and related information for
that patient. I would like to print the name of the patient the in the first
row it appears and then suppress it the next 2-3 times so that those cells
are left blank. The report will be much more readable this way.