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
Bookmarks