The excel file has column A & B. Column C is what I need to create.
Condition is when "column A" (Email) is not empty, then I need to keep the first occurrence of ColumnA + ColumnB. All other occurences can be deleted.
I tried with various options such as COUNTIF and FREQUENCY but not getting anywhere.
Please let me know the best approaches.