Selecting duplicates with complete row values

[#1]

How to select duplicate rows with conditions?
I have a table with duplicate IDs, but some of the values from other rows are missing. What I need to do is to delete the duplicate row with missing information and retain the complete one.

For example:

ID	Name	Age
1	Jane	12
1	Jane
2	John	16
3	Anna
3	Anna	15
4	Mark

Rows 3, 5 should be deleted. I know "Select duplicate rows( Match( :Col1, :Col2 ) );" but I'm not sure how to specify to select and delete those with blank :Age. Please help

[#2]

If there is always only 1 record for each person that has a non missing value for age then a simple

     Tables=>Summary

where you group on name and specify to calculate the mean of age.

[#3]

But I need to delete the blank duplicates

[#4 · Accepted solution]

If you run the Summary Platform as I specified, it will result in removing the specified rows.  Below is your sample data table, and the preview of what the results of running the Summary Platform will produce

The data you want removed has been removed.

[#5]

Got it! Big thanks