How do I remove rows with duplicate values except those that contains null end empty values?

Question

I want to use power query to remove rows with duplicate values in a column containing e-mail addresses. But I do not want to remove rows with duplicate null values or duplicate empty cells.

How do I accomplish that?

Answer 1

I came up with a different solution to the problem.

1. Create a custom column with values from a index column if the email column was emtpty/null but from the email column if it was not empty/null.
2. Remove duplicate rows from the newly created column.
3. Remove the custom column.

Worked fine with me!

I thought that I should share the solution if anyone else can be helped by it.