hi can someone guide me as how do I filter out cells that contains text ([Name of Reviewer]) and do a autofill in a new field ([team]) if the previous field ([Name of Reviewer]) contains text.
Original input:
| Name of Reviewer | Team |
| John | |
| #N/A | |
| Mary | |
| James | |
| #N/A | |
Desired Output:
| Name Of Reviewer | Team |
| John | ASC |
| #N/A | |
| Mary | ASC |
| James | ASC |
| #N/A | |
Cheers,
Lance
