Hi,
I have a table in Power Query, where I need to remove rows which have blanks in column 2, unless the value in column 1 is unique. In other words; Keep rows with blanks in column2 only if value in column1 is unique, and discard if not.
The attached workbook shows which rows to keep and which to discard, using this formula:
=IF(OR(AND(COUNTIF($A$2:$A$135,$A2)=1,ISBLANK($B2)),NOT(ISBLANK($B2))),"KEEP","DISCARD")
How is this done in Power Query?
Best regards,
Marbleking
Bookmarks