Forum Discussion
How can I keep only first rows
Hi Anonymous ,
I think there's two ways to achieve this based on the sample data provided:
-1- Select the [Dep] column then go to the Home tab > Remove Rows (dropdown) > Remove Duplicates. This should remove every instance of [Dep] after the first value encountered from the top of the table. This will rely on the table sorting being correct to ensure the instance of each [Dep] you want to keep being highest in the table.-2- Select the [AI #] column then the dropdown to the right of the column header then go to Text Filters > Does Not Contain... . In the dialog that opens, enter "." (with no quotations) into the 'Enter or select value' box. This will filter all rows that have a duplicated [AI #] value, but relies on the system always assigning '.1', '.2' etc. to the end of the [AI #] values when they are duplicated.
Pete
Hi Anonymous ,
I think there's two ways to achieve this based on the sample data provided:
-1- Select the [Dep] column then go to the Home tab > Remove Rows (dropdown) > Remove Duplicates. This should remove every instance of [Dep] after the first value encountered from the top of the table. This will rely on the table sorting being correct to ensure the instance of each [Dep] you want to keep being highest in the table.
-2- Select the [AI #] column then the dropdown to the right of the column header then go to Text Filters > Does Not Contain... . In the dialog that opens, enter "." (with no quotations) into the 'Enter or select value' box. This will filter all rows that have a duplicated [AI #] value, but relies on the system always assigning '.1', '.2' etc. to the end of the [AI #] values when they are duplicated.
Pete
Hi BA_Pete ,
Wow, thank you so much, for reference I've used 2nd option and it did work well. Thank you!