How can I keep only first rows

[Anonymous]

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%

[BA_Pete · Accepted solution]

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

[Anonymous]

Hi @BA_Pete ,

Wow, thank you so much, for reference I've used 2nd option and it did work well. Thank you!