Forum Discussion
How can I keep only first rows
Hello All!
I have a table with 9 columns. In those columns some data are duplicated, in some columns not. How can I keep only first rows of different data? for example, what I have:
| Dep | AI # | AI Name | Planned start | Actual start | Planned End | Actual End | Weigthed Average | Status |
| Sales | P1 | Instruments | 5/1/2024 | 5/1/2024 | 7/7/2024 | 7/7/2024 | 100% | 100% |
| Training | P2 | Log On Book | 3/1/2024 | 3/1/2024 | 5/31/2024 | 5/31/2024 | 100% | 16,5% |
| Training | P2.1 | A4 Paper | 3/1/2024 | 3/1/2024 | 5/31/2024 | 5/31/2024 | 50% | 33% |
| Training | P2.2 | Materials | 3/2/2024 | 8/2/2024 | 31/2/2024 | 15/3/2024 | 50% | 0% |
what I want to see:
| Dep | AI # | AI Name | Planned start | Actual start | Planned End | Actual End | Weigthed Average | Status |
| Sales | P1 | Instruments | 5/1/2024 | 5/1/2024 | 7/7/2024 | 7/7/2024 | 100% | 100% |
| Training | P2 | Log On Book | 3/1/2024 | 3/1/2024 | 5/31/2024 | 5/31/2024 | 100% | 16,5% |
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
2 Replies
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!