Hello [Reader], I have a little issue:

I have a worksheet that contains two rows. I would like to import data to another sheet and apply the following rule:

Row1 Row2
1 A
2 B
3
4 D
5 E
1 Alpha
3 C
6
7
8 J

Rule: Import Row1 and Row2 Where Row2 is not Blank and Row1 is Unique.

Rusult should be:

1 A
2 B
3 C
4 D
5 E
8 J

I tried to use Auto and Advanced filters, but was not able to get exactly what I want, furthermore, after filtering, I was not able to copy and paste it. Not sure why.

Thanks