Hi there,
I want to remove duplicated rows from my table. The real spreadsheet is huge, but in order to simplify it, I'm posting here a sample in this picture. It's a spreadsheet with clients, with Names, Ages and Countries. We have full data of most of our clients, but we have duplicated and incomplete rows we want to delete. I tried advanced filter and the duplicate removable bottom from Data menu but either doesn't work.
To understand better is easier to look at my sample. In this case, I want to delete rows:
3 (because I have row 2 with complete data)
5 (because I have row 6 with complete data)
9 (because I have row 8 with complete data).
IMPORTANT: In this case, I can't just make a normal filter and copy the visible cells to another spreadsheet, because I don't want to delete the row 4, notice that row 4 (José) is not a duplicated row, but it has no data (or incomplete data).
My question is, how can I delete only duplicate data (incomplete/blank), preserving not duplicated rows as the row number 4?
I want to remove duplicated rows from my table. The real spreadsheet is huge, but in order to simplify it, I'm posting here a sample in this picture. It's a spreadsheet with clients, with Names, Ages and Countries. We have full data of most of our clients, but we have duplicated and incomplete rows we want to delete. I tried advanced filter and the duplicate removable bottom from Data menu but either doesn't work.

To understand better is easier to look at my sample. In this case, I want to delete rows:
3 (because I have row 2 with complete data)
5 (because I have row 6 with complete data)
9 (because I have row 8 with complete data).
IMPORTANT: In this case, I can't just make a normal filter and copy the visible cells to another spreadsheet, because I don't want to delete the row 4, notice that row 4 (José) is not a duplicated row, but it has no data (or incomplete data).
My question is, how can I delete only duplicate data (incomplete/blank), preserving not duplicated rows as the row number 4?