I have three columns - Consultant,DocumentDate,ServiceDate
I have three scenarios,
- If the ServiceDate consists of the year ‘1900’ then use the document date.
- If Consultant has 3 (First middle Last) names, then remove the Middle name. and if it has more than 3 then ignore.
- Concatenate both Consultant and ServiceDate.
I have tried using keystrokes, but it is taking a more time and updating each row.
Is there any possibility to do faster without keystrokes.
Attached the sample file.