ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   How do I suppress repeating data in Excel (https://www.excelbanter.com/excel-discussion-misc-queries/193635-how-do-i-suppress-repeating-data-excel.html)

Kent E.

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.


All times are GMT +1. The time now is 04:58 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com