smmedeiros
Technical User
Appreciate any ideas or guidance.
I want to conditionally suppress rows based on current record compared to previous or next record. Whatever is easiest. Explored several write-ups using next and previous and can't seem to get this working.
My sample data is attached.
I have 2 columns, server and application
in some conditions, my server does not have an application.
in other conditions, i have multiple entries and i wish to remove the entry where there is blank row for the application where there is a 2nd or 3rd rows showing a unique application.
I do not want to blank out all rows that do not carry an application. Only those that the server name repeats itself and the first row for the application is blank.
Thank you in advance for suggestions.
I want to conditionally suppress rows based on current record compared to previous or next record. Whatever is easiest. Explored several write-ups using next and previous and can't seem to get this working.
My sample data is attached.
I have 2 columns, server and application
in some conditions, my server does not have an application.
in other conditions, i have multiple entries and i wish to remove the entry where there is blank row for the application where there is a 2nd or 3rd rows showing a unique application.
I do not want to blank out all rows that do not carry an application. Only those that the server name repeats itself and the first row for the application is blank.
Thank you in advance for suggestions.