Let's say there are two columns in Excel:
A B
tim@email.com josh@email.com
math@email.com angel@email.com
nil@email.com noemail
jorme@email.com
I want to put a condition such as:
A B C
tim@email.com josh@email.com josh@email.com
math@email.com angel@email.com angel@email.com
nil@email.com noemail nil@email.com
jorme@email.com jorme@email.com
Setting priority to B and if not available any email at b then take from A.
Pandas and Excel formula both will be ok.
