Dear Geeks
Hope all you are safe and well
I have a problem like below, this is end of my work flow, am unable to get a formula or pick a tool in my work flow for below , in pay_tpe column I expect either home or host for same person, if it is missing I want to insert a row with either home or host based on missing value, the complete row can be copied from above but missing value in pay_tpe will be based on condition.
Thanks in advance,
| Date | Name | Age | Location | Type | Pay_tpe |
| 01/12/2019 | Dave | 22 | London | In | Home |
| 01/12/2019 | Dave | 22 | London | Out | Host |
| 01/12/2019 | Alan | 25 | Paris | In | Host |
KR
Rj
